CHECK Table Level|([PayFrequency]=(3) OR [PayFrequency]=(2) OR [PayFrequency]=(1))
DEFAULT on column ModifiedDate|(getdate())
FOREIGN KEY|EmployeeID
|REFERENCES AdventureWorks.HumanResources.Employee (EmployeeID)
PRIMARY KEY (clustered)|EmployeeID, RateChangeDate
No foreign keys reference this table, or you do not have permissions on referencing tables.|