StateProvince Table (AdventureWorks)
Is a lookup table that contains the international standard codes identifying states and provinces within a country/region.
StateProvince Table Definition
The StateProvince table is contained in the Person schema.
Column |
Data type |
Nullability |
Description |
|---|---|---|---|
StateProvinceID |
int |
Not null |
Primary key. |
StateProvinceCode |
nchar(3) |
Not null |
State or province code. |
CountryRegionCode |
nvarchar(3) |
Not null |
Country or region code. Foreign key to CountryRegion.CountryRegionCode. |
IsOnlyStateProvinceFlag |
Flag (user-defined type) bit |
Not null |
0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, use CountryRegionCode. |
Name |
Name (user-defined type) nvarchar(50) |
Not null |
State or province description. |
TerritoryID |
int |
Not null |
ID of the Adventure Works sales territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID. |
rowguid |
uniqueidentifier |
Not null |
ROWGUIDCOL number uniquely identifying the row. Used to support a merge replication sample. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |