sp_help is a stored procedure introduced by SQL Server 2000 which reports information about any database object. For example, executing the following SQL command in the context of Northwind will return information related to the table Customers.
sp_help
Customers
