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 (such as "Catalog" followed by "Schema" and finally by "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 | - |
|
|