January 15, 2014 at 7:20 am
When you script at the table level there is no option to include the indexes.
I have been scripting at the database level, specify the object(s) and set script index to true.
Is there a way to set this default to true?
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 15, 2014 at 8:02 am
I may be missing your point, but when I go into Tools / Options / SQL Server Object Explorer / Scripting, I can set script indexes to true. From then on, when I script a table, I get the indexes too.
January 15, 2014 at 8:27 am
David McKinney (1/15/2014)
I may be missing your point, but when I go into Tools / Options / SQL Server Object Explorer / Scripting, I can set script indexes to true. From then on, when I script a table, I get the indexes too.
That is what I needed. Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply