DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column rowguid|(newid())
FOREIGN KEY|ProductCategoryID
|REFERENCES AdventureWorks.Production.ProductCategory (ProductCategoryID)
PRIMARY KEY (clustered)|ProductSubcategoryID