Tuesday, September 7, 2010

How do I list all the indexes on a particular table in sqlserver 2005?

USE YourDatabasename;
GO
EXEC sp_helpindex 'Your_Table_Name'
GO

No comments:

Post a Comment