Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

script all indexes on a table Expand / Collapse
Author
Message
Posted Wednesday, December 5, 2012 10:25 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:41 AM
Points: 361, Visits: 1,781
Hi,

I need to script only indexes on one sql2008 database table only. how to do this in management studio?

thanks.
Post #1393319
Posted Wednesday, December 5, 2012 11:06 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984

http://www.sqlservercentral.com/Forums/Topic401784-562-3.aspx#bm1171799


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1393327
Posted Thursday, December 6, 2012 2:02 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 1, 2013 10:17 AM
Points: 323, Visits: 984
chetan.aegis (12/6/2012)
When data is inserted in table a clustered index determines the physical order of data in a table.because the clustered index dedicated the physical storage order of the data in the table.a table contain only clustered index.



That's surly not the answer of the asked Question.


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1393372
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse