Generated using SQL Data Dictionary demo version.

Table Sales.Customer (19,820 rows)

Current customer information. Also see the Person and Store tables.

  Column Data Type Identity Nullable Default
PK CustomerID int X
Primary key.
FK PersonID int X
Foreign key to Person.BusinessEntityID
FK StoreID int X
Foreign key to Store.BusinessEntityID
FK TerritoryID int X
ID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID.
UK AccountNumber varchar(10)
Unique number identifying the customer assigned by the accounting system.
UK rowguid uniqueidentifier newid()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime getdate()
Date and time the record was last updated.



Referenced by:

Used by: