Generated using SQL Data Dictionary demo version.


Table Person.StateProvince (181 rows)


State and province lookup table.


  Column Data Type Identity Nullable Default
PK StateProvinceID int X
Primary key for StateProvince records.
UK StateProvinceCode nchar(3)
ISO standard state or province code.
UK, FK CountryRegionCode nvarchar(3)
ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
IsOnlyStateProvinceFlag Flag(bit) 1
0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
UK Name Name(nvarchar(50))
State or province description.
FK TerritoryID int
ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
UK rowguid uniqueidentifier newid()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime getdate()
Date and time the record was last updated.

Indexes:


References:


Referenced by:


Used by: