COUNTRY

This table lists the country or region names in each of the supported languages identified by LANGUAGE_ID. (Note that some of the entries may store the region name rather than the official country name in the NAME column for historical reasons.)

Column Descriptions:

NameTypeDescription
COUNTRYABBRCHAR (5) NOT NULLCountry or region abbreviation code. This code is derived from the ISO-3166 Alpha-2 codes. For countries or regions with multiple commonly used names a number or letter may be appended to the ISO-3166 alpha-2 code to form the abbreviation code.
LANGUAGE_IDINTEGER NOT NULLThe language of the value in the NAME column. For a list of language components, see the LANGUAGE table.
NAMEVARCHAR (254)Name of the country or region in the language identified by LANGUAGE_ID.
CALLINGCODEVARCHAR (16)The designated calling code of the country for placing International calls.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>COUNTRYABBR+LANGUAGE_IDPrimary Key
I0000342LANGUAGE_ID+NAMENon-Unique Index
I0000343NAMENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_257LANGUAGE_IDLANGUAGELANGUAGE_IDCascade