Use sp_help to display information about the properties of a system datatype or a user-defined datatype.
The output from sp_help includes the base type from which the datatype was created, whether it allows nulls, the names of any rules and defaults bound to the datatype, and whether it has the IDENTITY property.
sp_help money
Type_name Storage_type Length Prec Scale ---------- ------------ ------ ----- ----- money money 8 NULL NULL Nulls Default_name Rule_name Identity ----- ------------ --------- -------- 1 NULL NULL NULL (return status = 0) sp_help tid Type_name Storage_type Length Prec Scale ---------- ------------ ------ ----- ----- tid varchar 6 NULL NULL Nulls Default_name Rule_name Identity ----- ------------ --------- -------- 0 NULL NULL 0 (return status = 0)