| SQL portability / Naming database objects | |
Database object naming conventions are different for each database engine.
The table below describes the naming conventions for database objects (i.e. tables, sequences, stored procedures):
| Database Server Type | Naming Syntax |
|---|---|
| Genero db | [schema.]identifier |
| IBM® DB2® UDB | [[database.]owner.]identifier |
| IBM Informix® | [database[@dbservername]:][owner.]identifier |
| Microsoft™ SQL Server | [[[server.][database].][owner_name].]object_name |
| MySQL | [database.]identifier |
| Oracle Database Server | [schema.]identifier[@database-link] |
| PostgreSQL | [owner.]identifier |
| Sybase ASE | [database.]identifier |
| SQLite |
[database.]identifier |