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:
“We are all instruments endowed with feeling and memory. Our senses are so many strings that are struck by surrounding objects and that also frequently strike themselves.”
—Denis Diderot (171384)
“Though collecting quotations could be considered as merely an ironic mimetismvictimless collecting, as it were ... in a world that is well on its way to becoming one vast quarry, the collector becomes someone engaged in a pious work of salvage. The course of modern history having already sapped the traditions and shattered the living wholes in which precious objects once found their place, the collector may now in good conscience go about excavating the choicer, more emblematic fragments.”
—Susan Sontag (b. 1933)