sql=[sp_help "tPerson"
]
tPerson|dbo|user table|May 10 2005 02:25PM|
 
 
ID|int|no|4|10|0|no|(n/a)|(n/a)|
Person|varchar|no|50|||yes|no|no|
StartDate|datetime|no|8|||yes|(n/a)|(n/a)|
EndDate|datetime|no|8|||yes|(n/a)|(n/a)|
Active|bit|no|1|||yes|(n/a)|(n/a)|
EmailAddress|varchar|no|255|||yes|no|no|
 
ID|            1.000000|            1.000000|0|
 
No rowguidcol column defined.|
 
PRIMARY|
 
_WA_Sys_ID_73F33360|nonclustered, statistics, auto create located on PRIMARY|ID|
_WA_Sys_Person_73F33360|nonclustered, statistics, auto create located on PRIMARY|Person|
_WA_Sys_Active_73F33360|nonclustered, statistics, auto create located on PRIMARY|Active|
 
No constraints have been defined for this object.
 
No foreign keys reference this table.