Person.StateProvince

Field Name Data Type Size Original Type Default Nullable Description Check

StateProvinceID int identity 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 Flag bit (1) Not null 0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.

Name Name nvarchar(50) 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 newid() Not null ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description
StateProvinceID	int identity		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	Flag		bit	(1)	Not null	0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
Name	Name		nvarchar(50)		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			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Person.StateProvince'

Primary Key Name Field Name

PK_StateProvince_StateProvinceID StateProvinceID

Primary Key Name	Field Name
PK_StateProvince_StateProvinceID	StateProvinceID

Foreign keys for table 'Person.StateProvince', 2 items

Foreign Primary Key Name

StateProvince.CountryRegionCode CountryRegion.CountryRegionCode FK_StateProvince_CountryRegion_CountryRegionCode

StateProvince.TerritoryID SalesTerritory.TerritoryID FK_StateProvince_SalesTerritory_TerritoryID

Foreign	Primary	Key Name
StateProvince.CountryRegionCode	CountryRegion.CountryRegionCode	FK_StateProvince_CountryRegion_CountryRegionCode
StateProvince.TerritoryID	SalesTerritory.TerritoryID	FK_StateProvince_SalesTerritory_TerritoryID

Indexes for table 'Person.StateProvince', 4 items

Index Name Description Clustered Unique Fields

PK_StateProvince_StateProvinceID Clustered index created by a primary key constraint. Yes Yes StateProvinceID

AK_StateProvince_Name Unique nonclustered index. No Yes Name

AK_StateProvince_rowguid Unique nonclustered index. Used to support replication samples. No Yes rowguid

AK_StateProvince_StateProvinceCode_CountryRegionCode Unique nonclustered index. No Yes StateProvinceCode, CountryRegionCode

Index Name	Description	Clustered	Unique	Fields
PK_StateProvince_StateProvinceID	Clustered index created by a primary key constraint.	Yes	Yes	StateProvinceID
AK_StateProvince_Name	Unique nonclustered index.	No	Yes	Name
AK_StateProvince_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid
AK_StateProvince_StateProvinceCode_CountryRegionCode	Unique nonclustered index.	No	Yes	StateProvinceCode, CountryRegionCode

Triggers for table 'Person.StateProvince', 1 item

Name Description Type Enabled

uStateProvince AFTER UPDATE trigger setting the ModifiedDate column in the StateProvince table to the current date. after Update Yes

Name	Description	Type	Enabled
uStateProvince	AFTER UPDATE trigger setting the ModifiedDate column in the StateProvince table to the current date.	after Update	Yes

Dependencies for table 'Person.StateProvince', 7 items

Object Name Type Field Name

HumanResources.vEmployee view N/A

Person.uStateProvince trigger N/A

Person.vStateProvinceCountryRegion view N/A

Purchasing.vVendor view N/A

Sales.vIndividualCustomer view N/A

Sales.vSalesPerson view N/A

Sales.vStoreWithDemographics view N/A