The following table lists the optional features in SQL-2003 that are supported by Mimer SQL
| Feature ID | Feature Name |
|---|
| B021 | Direct SQL |
| B031 | Basic dynamic SQL |
| B032 | Extended dynamic SQL |
| B033 | Untyped SQL-invoked function arguments |
| F032 | CASCADE drop behavior |
| F033 | ALTER TABLE statement: DROP COLUMN clause |
| F034 | Extended REVOKE statement |
| F052 | Intervals and datetime arithmetic |
| F053 | OVERLAPS predicate |
| F111 | Isolation levels other than SERIALIZABLE |
| F121 | Basic diagnostics management |
| F171 | Multiple schemas per user |
| F191 | Referential delete actions |
| F222 | INSERT statement: DEFAULT VALUES clause |
| F231 | Privilege tables |
| F251 | Domain support |
| F271 | Compound character literals |
| F281 | LIKE enhancements |
| F341 | Usage tables |
| F361 | Subprogram support |
| F381 | Extended schema manipulation |
| F391 | Long identifiers |
| F393 | Unicode escapes in literals |
| F401-01 | NATURAL JOIN |
| F421 | NATIONAL CHARACTER |
| F431 | Read-only scrollable cursors |
| F441 | Extended set function support |
| F442 | Mixed column references in set functions |
| F491 | Constraint management |
| F555 | Enhanced seconds precision |
| F561 | Full value expressions |
| F731 | INSERT column privileges |
| F771 | Connection management |
| F781 | Self-referencing operations |
| S071 | SQL paths in function and type name resolution |
| T071 | BIGINT data type |
| T011 | Timestamp in Information Schema |
| T041-01 | BLOB data type |
| T041-02 | CLOB data type |
| T211-01 | Triggers activated on UPDATE, INSERT or DELETE of one base table |
| T211-02 | BEFORE triggers |
| T211-03 | AFTER triggers |
| T211-05 | Ability to specify a search condition that must be true before the trigger is invoked |
| T211-08 | Multiple triggers for the same event that are executed in the order in which they where created in the catalog |
| T212 | Enhanced trigger capability |
| T241 | START TRANSACTION statement |
| T441 | ABS and MOD functions |
| T501 | Enhanced EXISTS predicate |
| T551 | Optional key words for default syntax |
| T591 | UNIQUE constraints of possibly null columns |
| T690 | Collation support |
| T692 | Extended collation support |
| P001 | Stored modules |
| P002 | Computational completeness |
| P003 | Information Schema views |
| V001 | Mimer SQL extension |
