| SQL adaptation guide for SAP Sybase ASE 16.x / Data dictionary | |
Informix® uses the following form to identify an SQL object:
[database[@dbservername]:][{owner|"owner"}.]identifier
With Sybase ASE, an object name takes the following form:
[{database|[database]}.[{owner|[owner]}.]]{identifier|[identifier]}
Informix database object names are not case sensitive in non-ANSI databases.
Sybase ASE database objects names are case sensitive by default.
As a general rule, to write portable SQL, you should only use simple database object names without any database, server or owner qualifier and without quoted identifiers.
Always create and use tables and columns names in lower case.