Re: [sqlite] how to Add a Table in the existing Sqlite database at client machine
Using Fluent Migrator project you write the following class...
[Migration(201101011411)]
public class Version_002 : FluentMigrator.Migration
{
public override void Up()
{
Create.Column("ColumnName").OnTable("TableName").AsInt32().Nullable();
}
public override void Down()
{
Delete.Column("ColumnName").FromTable("TableName");
}
}
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Madhan Kumar
Sent: 22 August 2011 13:27
To: sqlite-users@sqlite.org
Subject: [sqlite] how to Add a Table in the existing Sqlite database at client
machine
I,
I am using C# windows application(.Net2010) with sqlite,
Can you pls let me know, how to add or modify a new column/ table in
the existing Sqlite database that is in my client desktop machine.
I want the existing database to have its data(not disturbed), and only add a
new table/column.
Is there any way something like bat file - to execute and update the
database file in client machine.
or any other way to execute the scripts( like oracle updation of script)
Waiting for your reply.
Thanks
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] how to Add a Table in the existing Sqlite database at client machine
I, I am using C# windows application(.Net2010) with sqlite, Can you pls let me know, how to add or modify a new column/ table in the existing Sqlite database that is in my client desktop machine. I want the existing database to have its data(not disturbed), and only add a new table/column. Is there any way something like bat file - to execute and update the database file in client machine. or any other way to execute the scripts( like oracle updation of script) Waiting for your reply. Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to add a table ?
Le 14 juin 06 à 18:33, Eduardo a écrit : At 04:56 14/06/2006, you wrote: Hello, I have a database. I want to add a table with columns id integer name varchar addresse varchar ... Which instructions (exactly) I have to give. Check this page http://www.sqlite.org/sqlite.html , there are the basic SQL commands for manage a database, including create table. Thank you, I have already had solution. It was a question of adding a table to an existing base. I did not think that it was the same command that for a creation. Simple and efficient ! -- Thierry NAUZESaint-Denis de la Réunion
Re: [sqlite] How to add a table ?
At 04:56 14/06/2006, you wrote: Hello, I have a database. I want to add a table with columns id integer name varchar addresse varchar ... Which instructions (exactly) I have to give. Check this page http://www.sqlite.org/sqlite.html , there are the basic SQL commands for manage a database, including create table. I work with REALBASIC 2006 on Mac Thank you I have seen Joe Strout posting here, he was (or is) a developer of realbasic (from version 2.x up to 4.5), perhaps he can help you more. HTH - Antivirus. Warning: Usuario detectado. Por favor retirese del ordenador o sera ud. eliminado. Gracias
[sqlite] How to add a table ?
Hello, I have a database. I want to add a table with columns id integer name varchar addresse varchar ... Which instructions (exactly) I have to give. I work with REALBASIC 2006 on Mac Thank you -- Thierry NAUZESaint-Denis de la Réunion
