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:
“The objects of a financier are, then, to secure an ample revenue; to impose it with judgment and equality; to employ it economically; and, when necessity obliges him to make use of credit, to secure its foundations in that instance, and for ever, by the clearness and candour of his proceedings, the exactness of his calculations, and the solidity of his funds.”
—Edmund Burke (1729–1797)
“The sort of poetry I seek resides in objects Man can’t touch.”
—E.M. (Edward Morgan)