Properties

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.

Columns

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

Total: 3 column(s)

Indexes

	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	1

Total: 1 object(s)

Objects that depend on [Person].[CountryRegion]

	Object Name	Owner	Object Type	Dep Level
	CountryRegionCurrency	Sales	Table	1
	StateProvince	Person	Table	1
	vStateProvinceCountryRegion	Person	View	2
	Address	Person	Table	2
	SalesTaxRate	Sales	Table	2
	CustomerAddress	Sales	Table	3
	EmployeeAddress	HumanResources	Table	3
	SalesOrderHeader	Sales	Table	3
	VendorAddress	Purchasing	Table	3
	vEmployee	HumanResources	View	4
	vIndividualCustomer	Sales	View	4
	vSalesPerson	Sales	View	4
	vSalesPersonSalesByFiscalYears	Sales	View	4
	vStoreWithDemographics	Sales	View	4
	vVendor	Purchasing	View	4
	SalesOrderDetail	Sales	Table	4
	SalesOrderHeaderSalesReason	Sales	Table	4
	uSalesOrderHeader	Sales	Trigger	4
	iduSalesOrderDetail	Sales	Trigger	5

Total: 19 object(s)

SQL

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
    (
        [CountryRegionCode]
    )  ON [PRIMARY]
) ON [PRIMARY]
GO

See Also

List of tables