Sybase Adaptive Server Enterprise Reference

Technical information on Sybase Adaptive Server Enterprise (Sybase ASE).

Identifiers

Names for database objects such as databases, tables, views, columns, indexes, triggers, procedures etc.

First character	Alphabetical and _ (underscore)
Temporary tables	Begin with # (pound sign)
Variables and parameters	Begin with @ (at sign)
Subsequent characters	Alphanumeric, _ , #, @, $, ¥ (yen), and £ (pound sterling)

Max length:

Tables, columns, indexes, views, procedures, triggers	255
Databases, cursors, servers, logins, users, devices	30

Built-in data types:

CHAR(n)

1 ⇐ n ⇐ pagesize (2 KB, 4 KB, 8 KB or 16 KB)

Fixed-length character string