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
