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.