Describe in SQL Server

In next couple of posts i will explain about some very usefull stored procedures in SQL Server.

SP_HELP: SP_HELP [OBJECT | USER_DEFINED_DATATYPE]

The sp_help stored procedure is used to display information about a database object that is passed as a parameter.

The parameter is optional. If you want to display all the objects with in the current database then don’t pass any parameter. If you are looking for specific objects information then pass the object name.

USE master
EXEC sp_help

The above code is used to display information about each object in Sysobjects.