Other Objects
Information about what other objects are supported natively.
| Data Domain | Cursor | Trigger | Function 1 | Procedure 1 | External routine 1 | |
|---|---|---|---|---|---|---|
| 4th Dimension | Yes | No | Yes | Yes | Yes | Yes |
| ADABAS | ? | Yes | ? | Yes? | Yes? | ? |
| Adaptive Server Enterprise | Yes | Yes | Yes | Yes | Yes | Yes |
| Advantage Database Server | Yes | Yes | Yes | Yes | Yes | Yes |
| Altibase | Yes | Yes | Yes | Yes | Yes | Yes |
| Apache Derby | No | Yes | Yes | Yes 2 | Yes 2 | Yes 2 |
| CUBRID | Yes | Yes | Yes | Yes | Yes 2 | Yes |
| Drizzle | Yes | Yes | Yes 4 | Yes 4 | Yes 4 | Yes 4 |
| Empress Embedded Database | Yes via RANGE CHECK | Yes | Yes | Yes | Yes | Yes |
| DB2 | Yes via CHECK CONSTRAINT | Yes | Yes | Yes | Yes | Yes |
| Firebird | Yes | Yes | Yes | Yes | Yes | Yes |
| HSQLDB | Yes | No | Yes | Yes | Yes | Yes |
| H2 | Yes | No | Yes 2 | Yes 2 | Yes 2 | Yes |
| Informix Dynamic Server | Yes via CHECK | Yes | Yes | Yes | Yes | Yes |
| Ingres | Yes | Yes | Yes | Yes | Yes | Yes |
| InterBase | Yes | Yes | Yes | Yes | Yes | Yes |
| Linter SQL RDBMS | No | Yes | Yes | Yes | Yes | No |
| LucidDB | No | Yes | No | Yes 2 | Yes 2 | Yes 2 |
| MaxDB | Yes | Yes | Yes | Yes | Yes | ? |
| Microsoft Access (JET) | Yes | No | No | No | Yes, But single DML/DDL Operation | Yes |
| Microsoft Visual Foxpro | No | Yes | Yes | Yes | Yes | Yes |
| Microsoft SQL Server | Yes (2000 and beyond) | Yes | Yes | Yes | Yes | Yes |
| Microsoft SQL Server Compact (Embedded Database) | No | Yes | No | No | No | No |
| MonetDB | No | No | Yes | Yes | Yes | Yes |
| MySQL | No 3 | Yes | Yes | Yes | Yes | Yes |
| OpenBase SQL | Yes | Yes | Yes | Yes | Yes | Yes |
| Oracle | Yes | Yes | Yes | Yes | Yes | Yes |
| Oracle Rdb | Yes | Yes | Yes | Yes | Yes | Yes |
| OpenLink Virtuoso | Yes | Yes | Yes | Yes | Yes | Yes |
| Polyhedra DBMS | No | No | Yes | Yes | Yes | Yes |
| PostgreSQL | Yes | Yes | Yes | Yes | Yes | Yes |
| RDM Embedded | No | Yes | No | No | Yes | Yes |
| RDM Server | No | Yes | Yes | No | Yes | Yes |
| ScimoreDB | No | No | No | No | Yes | Yes |
| SQL Anywhere | Yes | Yes | Yes | Yes | Yes | Yes |
| SQLite | No | No | Yes | No | No | Yes |
| Teradata | No | Yes | Yes | Yes | Yes | Yes |
| UniData | No | No | Yes | Yes | Yes | Yes |
| UniVerse | No | No | Yes | Yes | Yes | Yes |
| Xeround Cloud Database | No 3 | Yes | Yes | Yes | Yes | No |
| Data Domain | Cursor | Trigger | Function 1 | Procedure 1 | External routine 1 |
Note (1): Both function and procedure refer to internal routines written in SQL and/or procedural language like PL/SQL. External routine refers to the one written in the host languages, such as C, Java, Cobol, etc. "Stored procedure" is a commonly used term for these routine types. However, its definition varies between different database vendors.
Note (2): In Derby, H2, LucidDB, and CUBRID, users code functions and procedures in Java.
Note (3): ENUM datatype exist. CHECK clause is parsed, but not enforced in runtime.
Note (4): In Drizzle the user codes functions and procedures in C++.
Read more about this topic: Comparison Of Relational Database Management Systems
Famous quotes containing the word objects:
“My objects dream and wear new costumes,
compelled to, it seems, by all the words in my hands
and the sea that bangs in my throat.”
—Anne Sexton (1928–1974)
“Adultery itself in its principle is many times nothing but a curious inquisition after, and envy of another man’s enclosed pleasures: and there have been many who refused fairer objects that they might ravish an enclosed woman from her retirement and single possessor.”
—Jeremy Taylor (1613–1667)