Database entities

The database entity concept across different database engines.

Most database servers can handle multiple database entities (you can create multiple 'databases'), but this is not possible with all engines:

Table 1. Multiple database entities by Database server type
Database Server Type Multiple Database support
IBM® Informix® Yes, see details
Microsoft™ SQL Server Yes, see details
Oracle® MySQL / MariadDB Yes, see details
Oracle Database Server Yes, see details
PostgreSQL Yes, see details
SAP HANA® Yes, see details
SQLite Yes, see details

Dameng®

Yes, see details

When using a database server that does not support multiple database entities, you can emulate different databases with schema entities, but this requires you to check for the database user definition. Each database user must have privileges to access any schema, and to see any table of any schema without needing to set a schema prefix before table names in SQL statements.

Some database drivers allow to select a specific schema at connection with the following FGLPROFILE entry:
dbi.database.dbname.dbtype.schema = "schema-name"

Some databases also allow you to define a default schema for each database user. When the user connects to the database, the default schema is automatically selected.