sql=[sp_help "tExtension"
]
tExtension|dbo|user table|Nov 12 2010 03:44PM|
 
 
ext|varchar|no|20|||yes|no|no|
lname|varchar|no|50|||yes|no|no|
fname|varchar|no|30|||yes|no|no|
tec|varchar|no|50|||yes|no|no|
division|varchar|no|20|||yes|no|no|
location|varchar|no|50|||yes|no|no|
sect|varchar|no|50|||yes|no|no|
title|varchar|no|50|||yes|no|no|
email|varchar|no|60|||yes|no|no|
site|varchar|no|50|||yes|no|no|
extgrp|varchar|no|50|||yes|no|no|
date_updated|datetime|no|8|||yes|(n/a)|(n/a)|
hdate|datetime|no|8|||yes|(n/a)|(n/a)|
updop|char|no|1|||yes|no|yes|
 
No identity column defined.||||
 
No rowguidcol column defined.|
 
PRIMARY|
 
_WA_Sys_email_28D43D4F|nonclustered, statistics, auto create located on PRIMARY|email|
 
DEFAULT on column hdate|DF_tExtension_hdate|(n/a)|(n/a)|(1 / 11 / 2010)|
DEFAULT on column updop|DF_tExtension_updop|(n/a)|(n/a)|('O')|
 
No foreign keys reference this table.