From dbscript Online Help
wikibot
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| CustomerID
|
int
|
not null
|
|
PK_Customer_CustomerID
|
|
| TerritoryID
|
int
|
null
|
|
|
IX_Customer_TerritoryID
|
| AccountNumber
|
|
|
|
|
AK_Customer_AccountNumber
|
| CustomerType
|
nchar(1)
|
not null
|
|
|
|
| rowguid
|
uniqueidentifier
|
not null
|
(newid())
|
|
AK_Customer_rowguid
|
| ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
automatically generated
| Table
|
Sales.Customer
|
| Description
|
Current customer information. Also see the Individual and Store tables.
|
| Column
|
Data Type
|
Nullable
|
Default
|
Description
|
PK / Index
|
| CustomerID
|
int
|
not null
|
|
Primary key for Customer records.
|
PK_Customer_CustomerID
|
| TerritoryID
|
int
|
null
|
|
ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.
|
IX_Customer_TerritoryID
|
| AccountNumber
|
|
|
|
Unique number identifying the customer assigned by the accounting system.
|
AK_Customer_AccountNumber
|
| CustomerType
|
nchar(1)
|
not null
|
|
Customer type: I = Individual, S = Store
|
|
| rowguid
|
uniqueidentifier
|
not null
|
(NEWID())
|
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
|
AK_Customer_rowguid
|
| ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|
|
