Person.CountryRegion Table

Description

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

Properties

Creation Date	08/01/2010 08:40
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	238
Data Space Used	16.00 KB
Index Space Used	32.00 KB

Columns

Column Name	Description	Datatype	Length	Default
CountryRegionCode	ISO standard code for countries and regions.	nvarchar	3
Name	Country or region name.	dbo.Name	50
ModifiedDate	Date and time the record was last updated.	datetime	4	(getdate())

Indexes

Index	Description	Primary	Unique
AK_CountryRegion_Name	Unique nonclustered index.
PK_CountryRegion_CountryRegionCode	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_CountryRegionCurrency_CountryRegion_CountryRegionCode	Foreign key constraint referencing CountryRegion.CountryRegionCode.
FK_StateProvince_CountryRegion_CountryRegionCode	Foreign key constraint referencing CountryRegion.CountryRegionCode.

Objects that depend on Person.CountryRegion

Database Object	Object Type	Description	Dep Level
Person.Address	Table	Street address information for customers, employees, and vendors.	2
Sales.CountryRegionCurrency	Table	Cross-reference table mapping ISO currency codes to a country or region.	1
Sales.CustomerAddress	Table	Cross-reference table mapping customers to their address(es).	3
HumanResources.EmployeeAddress	Table	Cross-reference table mapping employees to their address(es).	3
iduSalesOrderDetail	Trigger	AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column.	5
Sales.SalesOrderDetail	Table	Individual products associated with a specific sales order. See SalesOrderHeader.	4
Sales.SalesOrderHeader	Table	General sales order information.	3
Sales.SalesOrderHeaderSalesReason	Table	Cross-reference table mapping sales orders to sales reason codes.	4
Sales.SalesTaxRate	Table	Tax rate lookup table.	2
Person.StateProvince	Table	State and province lookup table.	1
uSalesOrderHeader	Trigger	AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables.	4
HumanResources.vEmployee	View	Employee names and addresses.	1
Purchasing.VendorAddress	Table	Cross-reference mapping vendors and addresses.	3
Sales.vIndividualCustomer	View	Individual customers (names and addresses) that purchase Adventure Works Cycles products online.	1
Sales.vSalesPerson	View	Sales representiatives (names and addresses) and their sales-related information.	1
Sales.vSalesPersonSalesByFiscalYears	View	Uses PIVOT to return aggregated sales information for each sales representative.	4
Person.vStateProvinceCountryRegion	View	Joins StateProvince table with CountryRegion table.	1
Sales.vStoreWithDemographics	View	Stores (names and addresses) that sell Adventure Works Cycles products to consumers.	1
Purchasing.vVendor	View	Vendor (company) names and addresses and the names of vendor employees to contact.	1

Objects that Person.CountryRegion depends on

	Database Object	Object Type	Description	Dep Level
	dbo.Name	User Defined Data Type		1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Person].[CountryRegion](
	[CountryRegionCode] [nvarchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Name] [dbo].[Name] NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_CountryRegion_CountryRegionCode] PRIMARY KEY CLUSTERED 
(
	[CountryRegionCode] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Person].[CountryRegion] ADD  CONSTRAINT [DF_CountryRegion_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]

Related Objects

Person Schema
AdventureWorks Database