Name syntax

Database object naming conventions are different for each database engine.

The table below describes the naming conventions for database objects (tables, sequences, stored procedures):

Table 1. Database server naming conventions for database objects
Database Server Type Naming Syntax
IBM® DB2® LUW
[[database.]owner.]identifier
IBM Informix®
[database[@dbservername]:][owner.]identifier
Microsoft™ SQL Server
[[[server.][database].][owner_name].]object_name
Oracle® MySQL
[database.]identifier
Oracle Database Server
[schema.]identifier[@database-link]
PostgreSQL
[owner.]identifier
SAP® ASE
[database.]identifier
SAP HANA®
[[database.]schema.]identifier
SQLite
[database.]identifier