Databases > WideWorldImporters > Tables > Application.Countries

WideWorldImporters

Application.Countries

//
Countries that contain the states or provinces (including geographic boundaries)

SYSTEM VERSIONED

Created: Modified:

Columns

  • //
    ${escapify(column.description)}
    CountryID
    [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[CountryID])
  • //
    ${escapify(column.description)}
    CountryName
    [nvarchar](60) NOT NULL
  • //
    ${escapify(column.description)}
    FormalName
    [nvarchar](60) NOT NULL
  • //
    ${escapify(column.description)}
    IsoAlpha3Code
    [nvarchar](3) NULL
  • //
    ${escapify(column.description)}
    IsoNumericCode
    [int] NULL
  • //
    ${escapify(column.description)}
    CountryType
    [nvarchar](20) NULL
  • //
    ${escapify(column.description)}
    LatestRecordedPopulation
    [bigint] NULL
  • //
    ${escapify(column.description)}
    Continent
    [nvarchar](30) NOT NULL
  • //
    ${escapify(column.description)}
    Region
    [nvarchar](30) NOT NULL
  • //
    ${escapify(column.description)}
    Subregion
    [nvarchar](30) NOT NULL
  • //
    ${escapify(column.description)}
    Border
    [geography] NULL
  • LastEditedBy
    [int] NOT NULL
  • ValidFrom
    [datetime2](8) NOT NULL
  • ValidTo
    [datetime2](8) NOT NULL

Indexes

  • PK_Application_Countries
    UNIQUE CLUSTERED
    CountryID
  • UQ_Application_Countries_FormalName
    UNIQUE NONCLUSTERED
    FormalName
  • UQ_Application_Countries_CountryName
    UNIQUE NONCLUSTERED
    CountryName

Foreign Keys

  • FK_Application_Countries_Application_People
    Application.People
    LastEditedBy ⥱ PersonID

Sample Data

CountryID
CountryName
FormalName
IsoAlpha3Code
IsoNumericCode
CountryType
LatestRecordedPopulation
Continent
Region
Subregion
Border
LastEditedBy
ValidFrom
ValidTo
1
Afghanistan
Islamic State of Afghanistan
AFG
4
UN Member State
28400000
Asia
Asia
Southern Asia
[geography]
1
3
Albania
Republic of Albania
ALB
8
UN Member State
3785031
Europe
Europe
Southern Europe
[geography]
20
4
Algeria
People's Democratic Republic of Algeria
DZA
12
UN Member State
34178188
Africa
Africa
Northern Africa
[geography]
1
6
Andorra
Principality of Andorra
AND
20
UN Member State
87243
Europe
Europe
Southern Europe
[geography]
15
7
Angola
People's Republic of Angola
AGO
24
UN Member State
12799293
Africa
Africa
Middle Africa
[geography]
1
10
Antigua and Barb.
Antigua and Barbuda
ATG
28
UN Member State
85632
North America
Americas
Caribbean
[geography]
1
11
Argentina
Argentine Republic
ARG
32
UN Member State
42550127
South America
Americas
South America
[geography]
15
12
Armenia
Republic of Armenia
ARM
51
UN Member State
2967004
Asia
Asia
Western Asia
[geography]
1
15
Australia
Commonwealth of Australia
AUS
36
UN Member State
22997671
Oceania
Oceania
Australia and New Zealand
[geography]
15
16
Austria
Republic of Austria
AUT
40
UN Member State
8210281
Europe
Europe
Western Europe
[geography]
1
17
Azerbaijan
Republic of Azerbaijan
AZE
31
UN Member State
8568218
Asia
Asia
Western Asia
[geography]
15
18
Bahamas
Commonwealth of the Bahamas
BHS
44
UN Member State
309156
North America
Americas
Caribbean
[geography]
1
19
Bahrain
Kingdom of Bahrain
BHR
48
UN Member State
727785
Asia
Asia
Western Asia
[geography]
1
20
Bangladesh
People's Republic of Bangladesh
BGD
50
UN Member State
156050883
Asia
Asia
Southern Asia
[geography]
1
21
Barbados
Barbados
BRB
52
UN Member State
284589
North America
Americas
Caribbean
[geography]
1
22
Belarus
Republic of Belarus
BLR
112
UN Member State
9648533
Europe
Europe
Eastern Europe
[geography]
1
23
Belgium
Kingdom of Belgium
BEL
56
UN Member State
10830909
Europe
Europe
Western Europe
[geography]
15
24
Belize
Belize
BLZ
84
UN Member State
307899
North America
Americas
Central America
[geography]
1
25
Benin
Republic of Benin
BEN
204
UN Member State
8791832
Africa
Africa
Western Africa
[geography]
1
27
Bhutan
Kingdom of Bhutan
BTN
64
UN Member State
691141
Asia
Asia
Southern Asia
[geography]
1
28
Bolivia
Plurinational State of Bolivia
BOL
68
UN Member State
9775246
South America
Americas
South America
[geography]
1
29
Bosnia and Herz.
Bosnia and Herzegovina
BIH
70
UN Member State
4797950
Europe
Europe
Southern Europe
[geography]
8
30
Botswana
Republic of Botswana
BWA
72
UN Member State
2070511
Africa
Africa
Southern Africa
[geography]
8
32
Brazil
Federative Republic of Brazil
BRA
76
UN Member State
198739269
South America
Americas
South America
[geography]
1
34
Brunei
Negara Brunei Darussalam
BRN
96
UN Member State
388190
Asia
Asia
South-Eastern Asia
[geography]
1