AdventureWorks2019
Person.CountryRegion
//
Lookup table containing the ISO standard codes for countries and regions.
Created: Modified:
Columns
-
//${escapify(column.description)}[nvarchar](3) NOT NULL
-
//${escapify(column.description)}[Name] NOT NULL//USER-DEFINED DATA TYPE[nvarchar](50) NULL
-
//${escapify(column.description)}[datetime] NOT NULL DEFAULT (getdate())
Indexes
-
//Clustered index created by a primary key constraint.PK_CountryRegion_CountryRegionCodeUNIQUE CLUSTEREDCountryRegionCode
-
//Unique nonclustered index.AK_CountryRegion_NameUNIQUE NONCLUSTEREDName
Sample Data
CountryRegionCode
Name
ModifiedDate
AD
Andorra
AE
United Arab Emirates
AF
Afghanistan
AG
Antigua and Barbuda
AI
Anguilla
AL
Albania
AM
Armenia
AN
Netherlands Antilles
AO
Angola
AQ
Antarctica
AR
Argentina
AS
American Samoa
AT
Austria
AU
Australia
AW
Aruba
AZ
Azerbaijan
BA
Bosnia and Herzegovina
BB
Barbados
BD
Bangladesh
BE
Belgium
BF
Burkina Faso
BG
Bulgaria
BH
Bahrain
BI
Burundi
BJ
Benin