DEFAULT on column IsOnlyStateProvinceFlag|((1))
DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column rowguid|(newid())
FOREIGN KEY|CountryRegionCode
|REFERENCES AdventureWorks.Person.CountryRegion (CountryRegionCode)
FOREIGN KEY|TerritoryID
|REFERENCES AdventureWorks.Sales.SalesTerritory (TerritoryID)
PRIMARY KEY (clustered)|StateProvinceID