DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column rowguid|(newid())
FOREIGN KEY|CustomerID
|REFERENCES AdventureWorks.Sales.Customer (CustomerID)
PRIMARY KEY (clustered)|CustomerID