Sybase Adaptive Server Enterprise - Reference and Migration

The reference provides technical information on Sybase Adaptive Server Enterprise (Sybase ASE) and its migration to other databases.

Last Update: Sybase Adaptive Server Enterprise 15.0

Migration Knowledge Base

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

DBA Scripts - Data