CHECK Table Level|([CustomerType]='I' OR [CustomerType]='i' OR [CustomerType]='S' OR [CustomerType]='s')
DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column rowguid|(newid())
FOREIGN KEY|SalesPersonID
|REFERENCES AdventureWorks.Sales.SalesPerson (SalesPersonID)
FOREIGN KEY|TerritoryID
|REFERENCES AdventureWorks.Sales.SalesTerritory (TerritoryID)
PRIMARY KEY (clustered)|CustomerID