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:
“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)
“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)
“Taught from their infancy that beauty is woman’s sceptre, the mind shapes itself to the body, and, roaming round its gilt cage, only seeks to adorn its prison. Men have various employments and pursuits which engage their attention, and give a character to the opening mind; but women, confined to one, and having their thoughts constantly directed to the most insignificant part of themselves, seldom extend their views beyond the triumph of the hour.”
—Mary Wollstonecraft (1759–1797)