Person.StateProvince (table)

wikibot

Table

Person.StateProvince

Column	Data Type	Nullable	Default	PK	Index
StateProvinceID	int	not null		PK_StateProvince_StateProvinceID
StateProvinceCode	nchar(3)	not null			AK_StateProvince_StateProvinceCode_CountryRegionCode
CountryRegionCode	nvarchar(3)	not null			AK_StateProvince_StateProvinceCode_CountryRegionCode
IsOnlyStateProvinceFlag	dbo.Flag	not null	((1))
Name	dbo.Name	not null			AK_StateProvince_Name
TerritoryID	int	not null
rowguid	uniqueidentifier	not null	(newid())		AK_StateProvince_rowguid
ModifiedDate	datetime	not null	(getdate())

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.

Referencing Object	Object Type	Reference Type
HumanResources.vEmployee	View	Select
Person.vStateProvinceCountryRegion	View	Select
Purchasing.vVendor	View	Select
Sales.vIndividualCustomer	View	Select
Sales.vSalesPerson	View	Select
Sales.vStoreWithDemographics	View	Select