Description
Lookup table containing the ISO standard codes for countries and regions.
Table properties
| name | value |
|---|
| name | [Person].[CountryRegion] |
| created | Mar 19 2009 9:09PM |
| modified | Mar 19 2009 9:10PM
|
| ansi nulls | on
|
| quoted identifier | on
|
| row count | 238 |
| Size of data | 16 kb |
| Size of indexes | 32 kb |
| Maximum size of a single row | 220 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| CountryRegionCode | nvarchar(3) | 3 | 12 | | no
| yes
| |
| no
| ISO standard code for countries and regions.
|
| Name | Name | 50 | 200 | | no
|
| |
| no
| Country or region name.
|
| ModifiedDate | datetime | 23 | 8 | (getdate()) | no
|
| |
| no
| Date and time the record was last updated.
|
Indexes
Referenced by
Foreign key graph
Defaults
Dependency graph
Objects that [Person].[CountryRegion] depends on
| name | object type | database | server | level |
|---|
| Name | type | AdventureWorks2008 | SPRING\KATMAI | 1 |
Objects that depend on [Person].[CountryRegion]
Sample rows
| CountryRegionCode | Name | ModifiedDate |
|---|
| AD
| Andorra
| 6/1/1998 12:00:00 AM
|
| AE
| United Arab Emirates
| 6/1/1998 12:00:00 AM
|
| AF
| Afghanistan
| 6/1/1998 12:00:00 AM
|
| AG
| Antigua and Barbuda
| 6/1/1998 12:00:00 AM
|
| AI
| Anguilla
| 6/1/1998 12:00:00 AM
|
| AL
| Albania
| 6/1/1998 12:00:00 AM
|
| AM
| Armenia
| 6/1/1998 12:00:00 AM
|
| AN
| Netherlands Antilles
| 6/1/1998 12:00:00 AM
|
| AO
| Angola
| 6/1/1998 12:00:00 AM
|
| AQ
| Antarctica
| 6/1/1998 12:00:00 AM
|
Code
CREATE TABLE [Person].[CountryRegion](
[CountryRegionCode] [nvarchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Name] [dbo].[Name] NOT NULL,
[CountryRegionCode] [nvarchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS 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]