syslanguages

Transact-SQL Reference

Transact-SQL Reference

syslanguages

Contains one row for each language present in Microsoft® SQL Server™. Although U.S. English is not in syslanguages, it is always available to SQL Server. This table is stored only in the master database.

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 Alternate 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 containing as many as 20 characters.
shortmonths varchar(132) Comma-separated list of short-month names in order from January through December, with each name containing as many as 9 characters.
days nvarchar(217) Comma-separated list of day names in order from Monday through Sunday, with each name containing as many as 30 characters.
lcid int Microsoft Windows NT® locale ID for the language.
mslangid smallint SQL Server message group ID.

Thirty-three SQL Server provided languages are installed. Here is a list of the languages.

Name in English NT LCID SQL Server 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