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 - 2001-06-27 : 13:24:13
|
| Virgil writes "I have several tables in a database which have Primary Key to Foreign Key relationships set up. All my primary keys are identity fields. I am trying to write SQL scripts that will allow me to take the code and place it on another server which does not have access to my SQL Server to use DTS. I want to insert control data in several realted tables. Is it possible using the ALTER TABLE statement to add an identity on a field after the table has been created and data inserted?" |
|
|
|
|
|
ALTER TABLE and identities