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

Data Types

Built-in data types:

CHAR(n) 1 ⇐ n ⇐ pagesize (2 KB, 4 KB, 8 KB or 16 KB) Fixed-length character string

Catalog Queries

DBA Scripts - Data