Reports information about a database object (any object listed in the sysobjects table) or about a SQL Server - supplied or user-defined datatype.
sp_help [objname]
where
The sp_help system stored procedure looks for an object in the current database only.
When no objname parameter is specified, sp_help lists object names, owners, and object types for all objects in the current database.
System procedures do not work on temporary tables because a procedure cannot access a temporary object unless the procedure created the object itself during the current session.
This example lists information about each object in sysobjects.
sp_help
This example displays information about the publishers table.
sp_help publishers
Execute permission defaults to the public group.
master.dbo.spt_values, syscolumns, sysindexes, sysobjects, systypes
sp_helpgroup | sp_helpsql |
sp_helpindex | sp_helpuser |
sp_helprotect |