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 - 2006-12-12 : 07:34:57
|
| ravi writes "plz tell me code for1. i want to create a table with same structure and key value as an existing table.2. How can i modify the primary key there i new table" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-12 : 07:36:57
|
| 1. Generate script of source table, modify table name in the script and run it in the desired database.2. Alter Table Drop Constraint ... Alter table Add Constraint ...Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
creating duplicate table