sys.syslanguages (Transact-SQL)

Contains one row for each language present in the instance of SQL Server.

Column name

Data type

Description

langid

smallint

Unique language ID.

dateformat

nchar(3)

Date order, for example, DMY.

datefirst

tinyint

First day of the week: 1 for Monday, 2 for Tuesday, and so on through 7 for Sunday.

upgrade

int

Reserved for system use.

name

sysname

Official language name, for example, Français.

alias

sysname

Alternative language name, for example, French.

months

nvarchar(372)

Comma-separated list of full-length month names in order from January through December, with each name having up to 20 characters.

shortmonths

varchar(132)

Comma-separated list of short-month names in order from January through December, with each name having up to 9 characters.

days

nvarchar(217)

Comma-separated list of day names in order from Monday through Sunday, with each name having up to 30 characters.

lcid

int

Microsoft Windows locale ID for the language.

msglangid

smallint

Database Engine message group ID.

The Database Engine contains the following installed languages.

Name in English

Windows LCID

Database Engine message group ID

English

1033

1033

German

1031

1031

French

1036

1036

Japanese

1041

1041

Danish

1030

1030

Spanish

3082

3082

Italian

1040

1040

Dutch

1043

1043

Norwegian

2068

2068

Portuguese

2070

2070

Finnish

1035

1035

Swedish

1053

1053

Czech

1029

1029

Hungarian

1038

1038

Polish

1045

1045

Romanian

1048

1048

Croatian

1050

1050

Slovak

1051

1051

Slovene

1060

1060

Greek

1032

1032

Bulgarian

1026

1026

Russian

1049

1049

Turkish

1055

1055

British English

2057

1033

Estonian

1061

1061

Latvian

1062

1062

Lithuanian

1063

1063

Brazilian

1046

1046

Traditional Chinese

1028

1028

Korean

1042

1042

Simplified Chinese

2052

2052

Arabic

1025

1025

Thai

1054

1054