Wednesday, July 13, 2011

How do

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

USE YourDatabasename;
GO
EXEC sp_helpindex 'Your_Table_Name'
GO

How do we list all the statistics for particular table?

USE URDATABASE;
GO
EXEC sp_helpstats 'YOUR_Table_Name'
GO

No comments:

Post a Comment