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 |
|
|
| DB2 | - |
|
|
| DB2 ZOS | - |
|
|
| Informix | - |
|
|
| Ingres | - |
|
|
| Microsoft SQL Server | - |
|
|
| MySQL | - |
|
|
| Netezza | - |
|
|
| Oracle | - |
|
|
| PointBase | - |
|
|
| PostgreSQL | - |
|
|
| SQLite | - |
|
|
| Sybase | - |
|
|
| Teradata | - |
|
|