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.
|