Monday, May 24, 2021

Scripting Tables with Indexes in SQL Server Management Studio

 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