Wednesday, May 25, 2016

Enable scripting of table indexes in SQL Server Management Studio

By Steve Endow

If you create custom tables for Dynamics GP customizations or have situations where you need to backup and recreate tables via SQL script, you've probably used the "Script Table" feature in SQL Server Management Studio.

But if you have ever scripted a table, you have probably noticed that by default, SQL Server Management Studio does not include table indexes.  This is a pretty big omission.

You can change this behavior in Management Studio Options, but I always forget where to find the setting and end up spending 5 minutes every time trying to find the setting.

So, documenting the location for posterity, it is under Tools -> Options -> SQL Server Object Explorer -> Scripting.

Set Script Indexes to True.

While you are at it, you may want to also enable "Check for object existence" and "Script permissions" as well.

Steve Endow is a Microsoft MVP for Dynamics GP and a Dynamics GP Certified IT Professional in Los Angeles.  He is the owner of Precipio Services, which provides Dynamics GP integrations, customizations, and automation solutions.

You can also find him on Google+ and Twitter

No comments: