OK, so you got some tables you want to script out for whatever reason.
You notice when you do, some of your indexes are missing.
What the heck?
No biggie...just need to set some default from false to True.
SSMS->Tools->Options->SQL Server Object Explorer->Scripting->Table and view options (on right)
Toggle Script Indexes to True.
If you use triggers or other options there, I would toggle them to true as well.
Reference...
https://stackoverflow.com/questions/3067599/script-table-as-create-via-ssms-doesnt-show-unique-index
No comments:
Post a Comment