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