sys.syslanguages (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008)yesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

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 nvarchar(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

See Also

Compatibility Views (Transact-SQL)
Mapping System Tables to System Views (Transact-SQL)