| Column | Data Type | Nullable | Default | Description |
| StateProvinceID | int | not null | | Primary key for StateProvince records. |
| StateProvinceCode | nchar(3) | not null | | ISO standard state or province code. |
| CountryRegionCode | nvarchar(3) | not null | | ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode. |
| IsOnlyStateProvinceFlag | dbo.Flag | not null | ((1)) | 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode. |
| Name | dbo.Name | not null | | State or province description. |
| 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. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |