SQLCODE4YOU
If you want to gain technical knowledge, share it to the world...!!
Showing posts with label
List all indexes in SqlServer 2005
.
Show all posts
Showing posts with label
List all indexes in SqlServer 2005
.
Show all posts
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
Older Posts
Home
Subscribe to:
Posts (Atom)