Welcome Guest, you are in: <root> • Login

Page History: Person CountryRegion (table)

Compare Page Revisions

5 4 3 2 1 0 Current 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/02/11 09:05

wikibot ¶

Table	Person.CountryRegion
Description	Lookup table containing the ISO standard codes for countries and regions.

Columns ¶

Column	Data Type	Nullable	Default	Description
CountryRegionCode	nvarchar(3)	not null		ISO standard code for countries and regions.
Name	dbo.Name	not null		Country or region name.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key ¶

Primary Key	Columns
PK_CountryRegion_CountryRegionCode	CountryRegionCode

Indexes ¶

Index	Type	Columns
AK_CountryRegion_Name	Unique	Name

Detail Tables ¶

Detail Table	Column	Referencing Column
Sales.CountryRegionCurrency	CountryRegionCode	CountryRegionCode
Person.StateProvince	CountryRegionCode	CountryRegionCode

References ¶

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Schema	Schema	Person

Dependencies ¶

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