Catalogs and schemas in database systems
The structure of a database defines how objects are organized in the database.
Different data storage structures are used to store objects in databases. For example, the
highest-level structure "Catalog">"Schema">"Table" is not
applicable to all database types.
| Database name | Version | Catalog | Schema |
|---|---|---|---|
| AS/400 | V5R4 | Supported | Supported |
| DB2 | All versions | Not supported | Supported |
| DB2 ZOS | All versions | Not supported | Supported |
| Informix | All versions | Supported | Supported |
| Microsoft SQL Server | All versions | Supported | Supported |
| MySQL | All versions | Supported | Not supported |
| Netezza | All versions | Supported | Supported |
| Oracle | All versions | Not supported | Supported |
| PointBase | All versions | Not supported | Supported |
| PostgreSQL | All versions | Supported | Supported |
| SQLite | All versions | Not supported | Not supported |
| Sybase | All versions | Supported | Supported |
| Teradata | All versions | Not supported | Supported |