Table: 'Sales.Customer'

6 fields. 52 bytes.

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

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
CustomerIDint identity int Not nullPrimary key for Customer records. 
TerritoryIDint   NullID of the territory in which the customer is located. Foreign key to SalesTerritory.SalesTerritoryID. 
AccountNumbervarchar10  Not nullUnique number identifying the customer assigned by the accounting system. 
CustomerTypenchar1  Not nullCustomer type: I = Individual, S = Store(upper([CustomerType])='I' OR upper([CustomerType])='S')
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Sales.Customer'

Primary Key NameField Name

Foreign keys for table 'Sales.Customer', 1 item

ForeignPrimaryKey Name

Indexes for table 'Sales.Customer', 4 items

Index NameDescriptionClusteredUniqueFields
PK_Customer_CustomerIDClustered index created by a primary key constraint.YesYesCustomerID
AK_Customer_AccountNumberUnique nonclustered index.NoYesAccountNumber
AK_Customer_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid
IX_Customer_TerritoryIDNonclustered index.NoNoTerritoryID

Triggers for table 'Sales.Customer', 1 item

uCustomerAFTER UPDATE trigger setting the ModifiedDate column in the Customer table to the current date.after Update Yes

Dependencies for table 'Sales.Customer', 2 items

Object NameTypeField Name
dbo.ufnLeadingZerosscalar functionN/A
Sales.Customeruser tableCustomerID