sql=[sp_help "tElement"
]
tElement|dbo|user table|May 10 2005 02:25PM|
 
 
ID|int|no|4|10|0|no|(n/a)|(n/a)||
ElementCode|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Description|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
ServiceGroupID|int|no|4|10|0|yes|(n/a)|(n/a)||
PlatinumUpdate|bit|no|1|||yes|(n/a)|(n/a)||
Active|bit|no|1|||yes|(n/a)|(n/a)||
StartDate|datetime|no|8|||yes|(n/a)|(n/a)||
EndDate|datetime|no|8|||yes|(n/a)|(n/a)||
CustomerID|int|no|4|10|0|yes|(n/a)|(n/a)||
ReportGroupID|int|no|4|10|0|yes|(n/a)|(n/a)||
LostRevenueFlag|bit|no|1|||yes|(n/a)|(n/a)||
 
ID|            1.000000|            1.000000|0|
 
No rowguidcol column defined.|
 
PRIMARY|
 
PK_tElement|clustered, unique, primary key located on PRIMARY|ID|
 
DEFAULT on column LostRevenueFlag|CONSTRAINT_default_LostRevenueFlag|(n/a)|(n/a)|(n/a)|(n/a)|(0)|
PRIMARY KEY (clustered)|PK_tElement|(n/a)|(n/a)|(n/a)|(n/a)|ID|
 
No foreign keys reference table 'tElement', or you do not have permissions on
referencing tables.
No views with schema binding reference table 'tElement'.