CHECK Table Level|([EndDate]>=[StartDate] OR [EndDate] IS NULL)
DEFAULT on column ModifiedDate|(getdate())
FOREIGN KEY|DepartmentID
|REFERENCES AdventureWorks.HumanResources.Department (DepartmentID)
FOREIGN KEY|EmployeeID
|REFERENCES AdventureWorks.HumanResources.Employee (EmployeeID)
PRIMARY KEY (clustered)|EmployeeID, StartDate, DepartmentID
No foreign keys reference this table, or you do not have permissions on referencing tables.|