This is an old revision of the document!
Technical information on Sybase Adaptive Server Enterprise (Sybase ASE).
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 |