Person.CountryRegion

Table: 'Person.CountryRegion'

3 fields. 122 bytes.

Lookup table containing the ISO standard codes for countries and regions.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
CountryRegionCode	nvarchar	3			Not null	ISO standard code for countries and regions.
Name	Name		nvarchar(50)		Not null	Country or region name.
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.CountryRegion'

Primary Key Name	Field Name
PK_CountryRegion_CountryRegionCode	CountryRegionCode

There are no Foreign Keys for this table.

Indexes for table 'Person.CountryRegion', 2 items

Index Name	Description	Clustered	Unique	Fields
PK_CountryRegion_CountryRegionCode	Clustered index created by a primary key constraint.	Yes	Yes	CountryRegionCode
AK_CountryRegion_Name	Unique nonclustered index.	No	Yes	Name

Triggers for table 'Person.CountryRegion', 1 item

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

Dependencies for table 'Person.CountryRegion', 7 items

Object Name	Type	Field Name
HumanResources.vEmployee	view	N/A
Person.uCountryRegion	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