Topic last updated -- July 2003
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|