CHECK Table Level|([EndDate]>=[StartDate] OR [EndDate] IS NULL)
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)|SalesPersonID, StartDate, TerritoryID
No foreign keys reference this table, or you do not have permissions on referencing tables.|