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 |