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:

Name	Type	Description
COUNTRYABBR	CHAR (5) NOT NULL	Country 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_ID	INTEGER NOT NULL	The language of the value in the NAME column. For a list of language components, see the LANGUAGE table.
NAME	VARCHAR (254)	Name of the country or region in the language identified by LANGUAGE_ID.
CALLINGCODE	VARCHAR (16)	The designated calling code of the country for placing International calls.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	COUNTRYABBR+LANGUAGE_ID	Primary Key
I0000342	LANGUAGE_ID+NAME	Non-Unique Index
I0000343	NAME	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_257	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade

Related reference
Country and state code data model