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)
“Nobody seriously questions the principle that it is the function of mass culture to maintain public morale, and certainly nobody in the mass audience objects to having his morale maintained.”
—Robert Warshow (1917–1955)