Use sp_help to display information about a specified database object (that is, any object listed in sysobjects), a specified datatype (listed in systypes), or all objects and datatypes in the current database.
sp_help [objname]
Here is the output for the publishers table:
Name Owner Type -------------------------- ----------- ---------- publisher dbo user table (1 row affected)
Data_located_on_segment When_created ------------------------------ -------------------- default Jul 7 1997 1:43PM
Column_name Type Length Prec Scale
----------- ------- ------ ----- -----
pub_id char 4 NULL NULL
pub_name varchar 40 NULL NULL
city varchar 20 NULL NULL
state char 2 NULL NULL
Nulls Default_name Rule_name Identity
----- ------------- --------- --------
0 NULL pub_idrule 0
1 NULL NULL 0
1 NULL NULL 0
1 NULL NULL 0
index_name index_description index_keys index_max_rows_per_page
---------- ------------------ ---------- -----------------------
pubind clustered, unique pub_id 0
located on default
(1 row affected)
keytype object related_object related_keys ------- ---------- -------------- ------------ primary publishers -- none -- pub_id, *, *, *, *, * foreign titles publishers pub_id, *, *, *, *, * (1 row affected)
Object is not partitioned. (return status = 0)
If you execute sp_help without supplying an object name, the resulting report shows each object in sysobjects, along with its name, owner, and object type. Also shown is each user-defined datatype in systypes and its name, storage type, length, whether null values are allowed, and any defaults or rules bound to it. The report also notes if any primary or foreign key columns have been defined for a table or view.
sp_help lists any indexes on a table, including those created by defining unique or primary key constraints. However, it does not describe any information about the integrity constraints defined for a table. Use sp_helpconstraint to display information about any integrity constraints.
