Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Wednesday, February 3, 2016 6:11 PM
Points: 362, Visits: 1,814
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: 2 days ago @ 1:03 PM
Points: 323, Visits: 991

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: 2 days ago @ 1:03 PM
Points: 323, Visits: 991
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