syslanguages

master database only

Description

syslanguages contains one row for each language known to Adaptive Server. us_english is not in syslanguages, but it is always available to Adaptive Server.

Columns

The columns for syslanguages are:

Name

Datatype

Description

langid

smallint

Unique language ID

dateformat

char(3)

Date order; for example, “dmy”

datefirst

tinyint

First day of the week—1 for Monday, 2 for Tuesday, and so on, up to 7 for Sunday

upgrade

int

Adaptive Server version of last upgrade for this language

name

varchar(30)

Official language name, for example, “french”

alias

varchar(30)

Alternate language name, for example, “français”

months

varchar(251)

Comma-separated list of full-length month names, in order from January to December—each name is at most 20 characters long

shortmonths

varchar(119)

Comma-separated list of shortened month names, in order from January to December—each name is at most 9 characters long

days

varchar(216)

Comma-separated list of day names, in order from Monday to Sunday—each name is at most 30 characters long

Indexes

Unique clustered index On langid

Unique nonclustered index On alias, name