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:
| Database Server Type | Multiple Database support |
|---|---|
| IBM® DB2® LUW | Yes, see details |
| IBM Informix® | Yes, see details |
| IBM Netezza® | 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 |
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.