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:
“All my life I have said, “Whatever happens there will always be tables and chairs”—and what a mistake.”
—Elizabeth Bowen (1899–1973)
“Hast thou named all the birds without a gun?
Loved the wood rose, and left it on its stalk?
At rich men’s tables eaten bread and pulse?
Unarmed, faced danger with a heart of trust?”
—Ralph Waldo Emerson (1803–1882)
“I shall do less whenever I shall believe what I am doing hurts the cause, and I shall do more whenever I shall believe doing more will help the cause. I shall try to correct errors when shown to be errors; and I shall adopt new views so fast as they shall appear to be true views.”
—Abraham Lincoln (1809–1865)