Owner: Person 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 16 
Index Size KB: 32 
Rows: 238 
Description: Lookup table containing the ISO standard codes for countries and regions. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    CountryRegionCode  nvarchar          ISO standard code for countries and regions. 
    Name  Name  100          Country or region name. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 3 column(s)


Index Primary Unique Description
  PK_CountryRegion_CountryRegionCode      Primary key (clustered) constraint 
  AK_CountryRegion_Name      Unique nonclustered index. 
Total: 2 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  Person.StateProvince  FK_StateProvince_CountryRegion_CountryRegionCode  PK_CountryRegion_CountryRegionCode 
  Sales.CountryRegionCurrency  FK_CountryRegionCurrency_CountryRegion_CountryRegionCode  PK_CountryRegion_CountryRegionCode 
Total: 2 table(s)

Objects that [Person].[CountryRegion] depends on

Object Name Owner Object Type Dep Level
  Name  dbo  User Defined type 
Total: 1 object(s)

Objects that depend on [Person].[CountryRegion]

Object Name Owner Object Type Dep Level
  CountryRegionCurrency  Sales  Table 
  StateProvince  Person  Table 
  vStateProvinceCountryRegion  Person  View 
  Address  Person  Table 
  SalesTaxRate  Sales  Table 
  CustomerAddress  Sales  Table 
  EmployeeAddress  HumanResources  Table 
  SalesOrderHeader  Sales  Table 
  VendorAddress  Purchasing  Table 
  vEmployee  HumanResources  View 
  vIndividualCustomer  Sales  View 
  vSalesPerson  Sales  View 
  vSalesPersonSalesByFiscalYears  Sales  View 
  vStoreWithDemographics  Sales  View 
  vVendor  Purchasing  View 
  SalesOrderDetail  Sales  Table 
  SalesOrderHeaderSalesReason  Sales  Table 
  uSalesOrderHeader  Sales  Trigger 
  iduSalesOrderDetail  Sales  Trigger 
Total: 19 object(s)


CREATE TABLE [CountryRegion] (
    [CountryRegionCode] [nvarchar] (3) COLLATE Latin1_General_CS_AS NOT NULL ,
    [Name] [Name] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_CountryRegion_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_CountryRegion_CountryRegionCode] PRIMARY KEY  CLUSTERED
    )  ON [PRIMARY]

See Also

List of tables