generating create scripts of entities

hello everyone,
probably a simple question, but i'm not sure how to tackle it. i have
several tables that i would like to build a creation script for. i
built the tables in enterprise manager, and tried to use the All
Tasks->Generate Sql Script action to generate the creation script for
these tables.
however, the script generated doesn't include any of the keys,
constraints, indexes, or default values that i specified for the table.
is there a way to include those in a script generation task? or do i
just have to add those manually to the script that is generated?
thanks,
jasonLook in the options tab. There's a check box for "Script PRIMARY keys,
FOREIGN keys, defaults, and check constraints".
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"jason" <iaesun@.yahoo.com> wrote in message
news:1123861220.532142.92370@.g43g2000cwa.googlegroups.com...
> hello everyone,
> probably a simple question, but i'm not sure how to tackle it. i have
> several tables that i would like to build a creation script for. i
> built the tables in enterprise manager, and tried to use the All
> Tasks->Generate Sql Script action to generate the creation script for
> these tables.
> however, the script generated doesn't include any of the keys,
> constraints, indexes, or default values that i specified for the table.
> is there a way to include those in a script generation task? or do i
> just have to add those manually to the script that is generated?
> thanks,
> jason
>|||Look at the options tab on the dialog box, and select the appropriate
checkboxes.
HTH,
Stu|||that's what i was missing, thanks a lot.
jason|||that's what i was missing, thanks a lot.
jason