Table: dbo.Country_Code | |||
Type table for ISO 3166-1 country codes. | |||
Columns | |||
Name | Type | Constraints | Description |
country_code_KEY | int (4) | NOT NULL | Primary Key |
country_name | nvarchar (90) | NOT NULL | English country name. |
country_code | nvarchar (4) | NOT NULL | ISO country code. |
Primary key | |||
Name | Columns | Description | |
PK_Country_Code | country_code_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Country_Code$country_code | country_code | ||
UK_Country_Code$country_name | country_name |