CHECK Table Level|([ActualEndDate]>=[ActualStartDate] OR [ActualEndDate] IS NULL OR [ActualStartDate] IS NULL)
CHECK Table Level|([ScheduledEndDate]>=[ScheduledStartDate])
DEFAULT on column ModifiedDate|(getdate())
FOREIGN KEY|LocationID
|REFERENCES AdventureWorks.Production.Location (LocationID)
FOREIGN KEY|WorkOrderID
|REFERENCES AdventureWorks.Production.WorkOrder (WorkOrderID)
PRIMARY KEY (clustered)|WorkOrderID, ProductID, OperationSequence
No foreign keys reference this table, or you do not have permissions on referencing tables.|