SQL SERVER Tips and Tricks

sp_help is a system stored procedure in sql server which is used to find the structure of the database objects.

syntax for sp_help is :

sp_help < database object Name>

Example : sp_help will retun all the following information in case  tables:

1. Table Name , database owner and table created time.
2. columns and their corresponding data types 
3. Identity column if any
4. constraints like primary key etc if any.

Below picture shows the execution result of sp_help system stored procedure for tableSTUDENT.



In case of stored procedures sp_help will return the following information:

• Stored procedure , database object owner and procedure created time
• Input and output parameters used in stored procedure if any.

Following picture represents the output of the sp_help for a stored procedure: