Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-04 : 14:25:57
|
| Raghavan writes "Hi,I have a database scripts which will create the tables in a database. For inserting the default values of the application which uses the database i have a xml data file.On executing the scripts the database will have the default initial values. After inserting the data i want to make the columns of the tables to be identity, without losing any data.How can this be done?I use sql server 2000 and windows 2000 sp5Thanx in advance" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-04 : 14:29:03
|
| You need to create another table with the structure that you want. Then move the data from your table into this table. Then drop your table. Then rename the new table to the old one's name. Then add the constraints and everything else that you need.Tara |
 |
|
|
|
|
|
Altering a column to make it identity