TechNet
Export (0) Print
Expand All

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 nameData typeDescription
langidsmallintUnique language ID.
dateformatnchar(3)Date order, for example, DMY.
datefirsttinyintFirst day of the week: 1 for Monday, 2 for Tuesday, and so on through 7 for Sunday.
upgradeintReserved for system use.
namesysnameOfficial language name, for example, Français.
aliassysnameAlternative language name, for example, French.
monthsnvarchar(372)Comma-separated list of full-length month names in order from January through December, with each name having up to 20 characters.
shortmonthsnvarchar(132)Comma-separated list of short-month names in order from January through December, with each name having up to 9 characters.
daysnvarchar(217)Comma-separated list of day names in order from Monday through Sunday, with each name having up to 30 characters.
lcidintMicrosoft Windows locale ID for the language.
msglangidsmallintDatabase Engine message group ID.

The Database Engine contains the following installed languages.

Name in EnglishWindows LCIDDatabase Engine message group ID
English10331033
German10311031
French10361036
Japanese10411041
Danish10301030
Spanish30823082
Italian10401040
Dutch10431043
Norwegian20682068
Portuguese20702070
Finnish10351035
Swedish10531053
Czech10291029
Hungarian10381038
Polish10451045
Romanian10481048
Croatian10501050
Slovak10511051
Slovene10601060
Greek10321032
Bulgarian10261026
Russian10491049
Turkish10551055
British English20571033
Estonian10611061
Latvian10621062
Lithuanian10631063
Brazilian10461046
Traditional Chinese10281028
Korean10421042
Simplified Chinese20522052
Arabic10251025
Thai10541054

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

Community Additions

ADD
Show:
© 2016 Microsoft