sql=[sp_help "tCustomer"
]
tCustomer|dbo|user table|May 10 2005 02:25PM|
 
 
ID|int|no|4|10|0|no|(n/a)|(n/a)||
ShipTo|varchar|no|4|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
FullName|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
VNumber|varchar|no|8|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Address01|varchar|no|255|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Address02|varchar|no|255|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Address03|varchar|no|255|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Address04|varchar|no|255|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Address05|varchar|no|255|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Address06|varchar|no|255|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Status|varchar|no|12|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
Rate|int|no|4|10|0|yes|(n/a)|(n/a)||
Invoice|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)||
LastUpdatedBy|varchar|no|50|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
PlatinumUpdate|bit|no|1|||yes|(n/a)|(n/a)||
InvoiceServices|bit|no|1|||yes|(n/a)|(n/a)||
eMailAddress|varchar|no|255|||yes|no|yes|SQL_Latin1_General_CP1_CI_AS|
eInvoice|bit|no|1|||yes|(n/a)|(n/a)||
MaxExServiceAmount|money|no|8|19|4|yes|(n/a)|(n/a)||
ARContactID|int|no|4|10|0|yes|(n/a)|(n/a)||
 
ID|            1.000000|            1.000000|0|
 
No rowguidcol column defined.|
 
PRIMARY|
 
IX_tCustomer|nonclustered located on PRIMARY|ARContactID|
PK_tCustomer|clustered, unique, primary key located on PRIMARY|ID|
 
DEFAULT on column InvoiceServices|CONSTRAINT_default_InvoiceServices|(n/a)|(n/a)|(n/a)|(n/a)|(0)|
PRIMARY KEY (clustered)|PK_tCustomer|(n/a)|(n/a)|(n/a)|(n/a)|ID|
 
No foreign keys reference table 'tCustomer', or you do not have permissions on
referencing tables.
No views with schema binding reference table 'tCustomer'.