description
sys.syslanguages (Transact-SQL)
title
sys.syslanguages (Transact-SQL) | Microsoft Docs
ms.custom
ms.date
03/15/2017
ms.prod
sql
ms.prod_service
database-engine, sql-database, synapse-analytics, pdw
ms.reviewer
ms.technology
system-objects
ms.topic
reference
f1_keywords
sys.syslanguages
sys.syslanguages_TSQL
syslanguages
syslanguages_TSQL
dev_langs
helpviewer_keywords
syslanguages system table
sys.syslanguages compatibility view
ms.assetid
f216d1cd-997c-42f0-a737-abbdfcd88383
author
WilliamDAssafMSFT
ms.author
wiassaf
monikerRange
>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current
sys.syslanguages (Transact-SQL) [!INCLUDE sql-asdb-asdbmi-asa-pdw ]
Contains one row for each language present in the instance of [!INCLUDEssNoVersion ].
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 [!INCLUDEmsCoName ] Windows locale ID for the language.
msglangid
smallint [!INCLUDEssDE ] message group ID.
The [!INCLUDEssDE ] contains the following installed languages.
Name in English
Windows LCID
[!INCLUDEssDE ] 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
Portuguese (Brazil)
1046
1046
Traditional Chinese
1028
1028
Korean
1042
1042
Simplified Chinese
2052
2052
Arabic
1025
1025
Thai
1054
1054
Compatibility Views (Transact-SQL) Mapping System Tables to System Views (Transact-SQL)