DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column rowguid|(newid())
FOREIGN KEY|StateProvinceID
|REFERENCES AdventureWorks.Person.StateProvince (StateProvinceID)
PRIMARY KEY (clustered)|AddressID