From dbscript Online Help
wikibot
Table
|
Person.StateProvince
|
Description
|
State and province lookup table.
|
Columns
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.
|
Primary Key
Primary Key
|
Columns
|
PK_StateProvince_StateProvinceID
|
StateProvinceID
|
Indexes
Index
|
Type
|
Columns
|
AK_StateProvince_Name
|
Unique
|
Name
|
AK_StateProvince_StateProvinceCode_CountryRegionCode
|
Unique
|
StateProvinceCode, CountryRegionCode
|
AK_StateProvince_rowguid
|
Unique
|
rowguid
|
Foreign Keys
Detail Tables
References
Dependency Type
|
Object Type
|
Referenced Object
|
Data Type
|
Type
|
dbo.Flag
|
Data Type
|
Type
|
dbo.Name
|
Schema
|
Schema
|
Person
|
Dependencies
automatically generated
Table
|
Person.StateProvince
|
Description
|
State and province lookup table.
|
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
|
Flag
|
not null
|
(1)
|
0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
|
Name
|
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.
|
Dependency Type
|
Object Type
|
Referenced Object
|
Data Type
|
Type
|
dbo.Flag
|
Data Type
|
Type
|
dbo.Name
|
Schema
|
Schema
|
Person
|