Tables and Views
Information about what tables and views (other than basic ones) are supported natively.
| Temporary table | Materialized view | |
|---|---|---|
| 4th Dimension | Yes | Planned for inclusion in next major release |
| ADABAS | ? | ? |
| Adaptive Server Enterprise | Yes1 | No |
| Advantage Database Server | Yes | No (only common views) |
| Altibase | Yes | No (only common views) |
| Apache Derby | Yes | No |
| CUBRID | No | No |
| Drizzle | Yes | No4 |
| DB2 | Yes | Yes |
| Empress Embedded Database | Yes | Yes |
| Firebird | Yes | No (only common views) |
| HSQLDB | Yes | No |
| H2 | Yes | No |
| Informix Dynamic Server | Yes | No2 |
| Ingres | Yes | Planned for inclusion in next major release |
| InterBase | Yes | No |
| Linter SQL RDBMS | Yes | Yes |
| LucidDB | No | No |
| MaxDB | Yes | No |
| Microsoft Access (JET) | No | No |
| Microsoft Visual Foxpro | Yes | Yes |
| Microsoft SQL Server | Yes | Yes3 |
| Microsoft SQL Server Compact (Embedded Database) | Yes | No |
| MonetDB/SQL | Yes | No |
| MySQL | Yes | No4 |
| OpenBase SQL | Yes | Yes |
| Oracle | Yes | Yes |
| Oracle Rdb | Yes | Yes |
| OpenLink Virtuoso | Yes | Yes |
| Polyhedra DBMS | No | No (only common views) |
| PostgreSQL | Yes | No5 |
| RDM Embedded | Yes | No |
| RDM Server | Yes | No |
| SQL Anywhere | Yes | Yes |
| ScimoreDB | No | No |
| SQLite | Yes | No |
| Teradata | Yes | Yes |
| UniData | Yes | No |
| UniVerse | Yes | No |
| Xeround Cloud Database | Yes | No |
Note (1): Server provides tempdb, which can be used for public and private (for the session) temp tables.
Note (2): Materialized views are not supported in Informix; the term is used in IBM’s documentation to refer to a temporary table created to run the view’s query when it is too complex, but one cannot for example define the way it is refreshed or build an index on it. The term is defined in the Informix Performance Guide.
Note (3): Query optimizer support only in Developer and Enterprise Editions. In other versions, a direct reference to materialized view and a query hint are required.
Note (4): Materialized views can be emulated using stored procedures and triggers.
Note (5): Materialized views can be emulated with stored procedures and triggers using PL/pgSQL, PL/Perl, PL/Python, or other procedural languages.
Read more about this topic: Comparison Of Relational Database Management Systems
Famous quotes containing the words tables and, tables and/or views:
“Players, Sir! I look on them as no better than creatures set upon tables and joint stools to make faces and produce laughter, like dancing dogs.”
—Samuel Johnson (1709–1784)
“Moving between the legs of tables and of chairs,
Rising or falling, grasping at kisses and toys,
Advancing boldly, sudden to take alarm,
Retreating to the corner of arm and knee,
Eager to be reassured, taking pleasure
In the fragrant brilliance of the Christmas tree....”
—T.S. (Thomas Stearns)
“The absolute things, the last things, the overlapping things, are the truly philosophic concerns; all superior minds feel seriously about them, and the mind with the shortest views is simply the mind of the more shallow man.”
—William James (1842–1910)