Useful MS-SQL Server System Stored Procedures

I am using the Adventure Works2008 database for this article. The Stored Procedures described here are very useful to speed up your work.

1. sp_help 'TableName'
-- returns the entire table structure.

For example: 

1. EXEC sp_help 'Production.Product' 

2. sp_spaceused 'TableName'
-- returns the memory related details of the table.

For example: 

1. EXEC sp_spaceused 'Production.Product' 

3. sp_helpconstraint 'TableName'
-- returns details of various constraints used in the table.

For example: 

1. exec sp_helpconstraint 'Production.Product' 

4. sp_helpindex 'TableName'
-- To get the Index details of a table.

For example: 

1. exec sp_helpindex 'Production.Product' 

5. sp_depends 'TableName'
--returns the list of Stored Procedures in which the table is used.

For example: 

1. exec sp_depends 'Production.Product' 

6. sp_depends 'StoredProcedureName'
-- returns the list of tables that are used in the current Stored Procedure.

For example:  

1. exec sp_depends 'dbo.ufnGetProductListPrice' 

7. sp_helptext 'StoredProcedureName'
Returns the strored procedure definition.

For example: 

1. EXEC sp_helptext 'dbo.ufnGetProductListPrice'