How to update database

[krishnaneeraja]

HI,

Iam developing c#.net windows application.In that iam using 12 tables and stored some data and build msi.But i want to add another 4 tables to my database and build msi,but I lost previous data.How to add these 4 tables to my database.plz help me.

Thanks & Regards
Neeraja.

[Frinavale]

HI,

Iam developing c#.net windows application.In that iam using 12 tables and stored some data and build msi.But i want to add another 4 tables to my database and build msi,but I lost previous data.How to add these 4 tables to my database.plz help me.

Thanks & Regards
Neeraja.

What database are you using?

Normally you create tables using SQL statements

eg
[code=sql]
CREATE TABLE mytable(
column_1 varchar(50),
column_2 date)
[/code]

-Frinny