Print this page.  If your browser doesn't allow JavaScript, right-click this page and choose Print from the popup-menu.        

Optional Features in SQL-99
Supported by Mimer SQL

The following table lists the optional features in SQL-99 that are supported by Mimer SQL

Feature IDFeature Name
B021Direct SQL
B031Basic dynamic SQL
B032Extended dynamic SQL
B033Untyped SQL-invoked function arguments
F032CASCADE drop behavior
F033ALTER TABLE statement: DROP COLUMN clause
F034Extended REVOKE statement
F052Intervals and datetime arithmetic
F053OVERLAPS predicate
F111Isolation levels other than SERIALIZABLE
F121Basic diagnostics management
F171Multiple schemas per user
F191Referential delete actions
F222INSERT statement: DEFAULT VALUES clause
F231Privilege tables
F251Domain support
F271Compound character literals
F281LIKE enhancements
F341Usage tables
F361Subprogram support
F381Extended schema manipulation
F391Long identifiers
F401-01NATURAL JOIN
F421NATIONAL CHARACTER
F431Read-only scrollable cursors
F441Extended set function support
F442Mixed column references in set functions
F491Constraint management
F555Enhanced seconds precision
F561Full value expressions
F731INSERT column privileges
F771Connection management
F781Self-referencing operations
S071SQL paths in function and type name resolution
T011Timestamp in Information Schema
T041-01BLOB data type
T041-02CLOB data type
T211-01Triggers activated on UPDATE, INSERT or DELETE of one base table
T211-02BEFORE triggers
T211-03AFTER triggers
T211-05Ability to specify a search condition that must be true before the trigger is invoked
T211-08Multiple triggers for the same event that are executed in the order in which they where created in the catalog
T212Enhanced trigger capability
T241START TRANSACTION statement
T441ABS and MOD functions
T501Enhanced EXISTS predicate
T551Optional key words for default syntax
T591UNIQUE constraints of possibly null columns
P001Stored modules
P002Computational completeness
P003Information Schema views
V001Mimer SQL extension

 

Powered by Mimer SQL

Powered by Mimer SQL