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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2009-04-21 : 14:00:53
|
| Hi,We have a schema with only table structure (no primary key, constraints etc) so we need to move all the following objects from other schema:• Primary key• Unique key• Non-clustered indexes• Default constraint• Check constraint • Foreign keysCheck constraints and foreign keys can be easily reversed engineer from 2nd schema using Management studio – Generate script since they were shown as alter table command.But Generate schema don’t give option to generate primary keys, unique keys, default constraints as alter command and that are embedded in table structure. Is it possible to get those as alter statement or there is any other script that someone have to go to metadata and generate these scripts. (script to generate primary keys, unique keys, default constraints etc)Thanks--Rubs |
|
|
|
|
|
Generate scripts for constraints