| B011 | | Embedded Ada | |
| B013 | | Embedded COBOL | |
| B014 | | Embedded Fortran | |
| B015 | | Embedded MUMPS | |
| B016 | | Embedded Pascal | |
| B017 | | Embedded PL/I | |
| B031 | | Basic dynamic SQL | |
| B032 | | Extended dynamic SQL | |
| B032-01 | | <describe input statement> | |
| B033 | | Untyped SQL-invoked function arguments | |
| B034 | | Dynamic specification of cursor attributes | |
| B041 | | Extensions to embedded SQL exception declarations | |
| B051 | | Enhanced execution rights | |
| B111 | | Module language Ada | |
| B112 | | Module language C | |
| B113 | | Module language COBOL | |
| B114 | | Module language Fortran | |
| B115 | | Module language MUMPS | |
| B116 | | Module language Pascal | |
| B117 | | Module language PL/I | |
| B121 | | Routine language Ada | |
| B122 | | Routine language C | |
| B123 | | Routine language COBOL | |
| B124 | | Routine language Fortran | |
| B125 | | Routine language MUMPS | |
| B126 | | Routine language Pascal | |
| B127 | | Routine language PL/I | |
| B128 | | Routine language SQL | |
| C011 | Core | Call-Level Interface | |
| E081 | Core | Basic Privileges | |
| E081-05 | Core | UPDATE privilege at the column level | |
| E081-07 | Core | REFERENCES privilege at the column level | |
| E081-09 | Core | USAGE privilege | |
| E121 | Core | Basic cursor support | |
| E121-06 | Core | Positioned UPDATE statement | |
| E121-07 | Core | Positioned DELETE statement | |
| E153 | Core | Updatable queries with subqueries | |
| E182 | Core | Module language | |
| F121 | | Basic diagnostics management | |
| F121-01 | | GET DIAGNOSTICS statement | |
| F121-02 | | SET TRANSACTION statement: DIAGNOSTICS SIZE clause | |
| F181 | Core | Multiple module support | |
| F262 | | Extended CASE expression | |
| F263 | | Comma-separated predicates in simple CASE expression | |
| F291 | | UNIQUE predicate | |
| F301 | | CORRESPONDING in query expressions | |
| F311 | Core | Schema definition statement | |
| F311-04 | Core | CREATE VIEW: WITH CHECK OPTION | |
| F312 | | MERGE statement | |
| F341 | | Usage tables | |
| F392 | | Unicode escapes in identifiers | |
| F393 | | Unicode escapes in literals | |
| F402 | | Named column joins for LOBs, arrays, and multisets | |
| F442 | | Mixed column references in set functions | |
| F451 | | Character set definition | |
| F461 | | Named character sets | |
| F521 | Enhanced integrity management | Assertions | |
| F641 | | Row and table constructors | |
| F661 | | Simple tables | |
| F671 | Enhanced integrity management | Subqueries in CHECK | intentionally omitted |
| F691 | | Collation and translation | |
| F692 | | Enhanced collation support | |
| F693 | | SQL-session and client module collations | |
| F695 | | Translation support | |
| F696 | | Additional translation documentation | |
| F721 | | Deferrable constraints | foreign keys only |
| F731 | | INSERT column privileges | |
| F741 | | Referential MATCH types | no partial match yet |
| F751 | | View CHECK enhancements | |
| F811 | | Extended flagging | |
| F812 | Core | Basic flagging | |
| F813 | | Extended flagging | |
| F821 | | Local table references | |
| F831 | | Full cursor update | |
| F831-01 | | Updatable scrollable cursors | |
| F831-02 | | Updatable ordered cursors | |
| S011 | Core | Distinct data types | |
| S011-01 | Core | USER_DEFINED_TYPES view | |
| S023 | Basic object support | Basic structured types | |
| S024 | Enhanced object support | Enhanced structured types | |
| S025 | | Final structured types | |
| S026 | | Self-referencing structured types | |
| S027 | | Create method by specific method name | |
| S028 | | Permutable UDT options list | |
| S041 | Basic object support | Basic reference types | |
| S043 | Enhanced object support | Enhanced reference types | |
| S051 | Basic object support | Create table of type | |
| S081 | Enhanced object support | Subtables | |
| S091 | | Basic array support | |
| S091-01 | | Arrays of built-in data types | |
| S091-02 | | Arrays of distinct types | |
| S091-03 | | Array expressions | |
| S092 | | Arrays of user-defined types | |
| S094 | | Arrays of reference types | |
| S095 | | Array constructors by query | |
| S096 | | Optional array bounds | |
| S097 | | Array element assignment | |
| S151 | Basic object support | Type predicate | |
| S161 | Enhanced object support | Subtype treatment | |
| S162 | | Subtype treatment for references | |
| S201 | | SQL-invoked routines on arrays | |
| S201-01 | | Array parameters | |
| S201-02 | | Array as result type of functions | |
| S202 | | SQL-invoked routines on multisets | |
| S231 | Enhanced object support | Structured type locators | |
| S232 | | Array locators | |
| S233 | | Multiset locators | |
| S241 | | Transform functions | |
| S242 | | Alter transform statement | |
| S251 | | User-defined orderings | |
| S261 | | Specific type method | |
| S271 | | Basic multiset support | |
| S272 | | Multisets of user-defined types | |
| S274 | | Multisets of reference types | |
| S275 | | Advanced multiset support | |
| S281 | | Nested collection types | |
| S291 | | Unique constraint on entire row | |
| T011 | | Timestamp in Information Schema | |
| T041 | Basic object support | Basic LOB data type support | |
| T041-01 | Basic object support | BLOB data type | |
| T041-02 | Basic object support | CLOB data type | |
| T041-03 | Basic object support | POSITION, LENGTH, LOWER, TRIM, UPPER, and SUBSTRING functions for LOB data types | |
| T041-04 | Basic object support | Concatenation of LOB data types | |
| T041-05 | Basic object support | LOB locator: non-holdable | |
| T042 | | Extended LOB data type support | |
| T051 | | Row types | |
| T052 | | MAX and MIN for row types | |
| T053 | | Explicit aliases for all-fields reference | |
| T061 | | UCS support | |
| T111 | | Updatable joins, unions, and columns | |
| T121 | | WITH (excluding RECURSIVE) in query expression | |
| T122 | | WITH (excluding RECURSIVE) in subquery | |
| T131 | | Recursive query | |
| T132 | | Recursive query in subquery | |
| T152 | | DISTINCT predicate with negation | |
| T172 | | AS subquery clause in table definition | |
| T173 | | Extended LIKE clause in table definition | |
| T174 | | Identity columns | |
| T175 | | Generated columns | |
| T176 | | Sequence generator support | |
| T211 | Active database, Enhanced integrity management | Basic trigger capability | |
| T211-05 | Active database, Enhanced integrity management | Ability to specify a search condition that must be true before the trigger is invoked | |
| T211-06 | Active database, Enhanced integrity management | Support for run-time rules for the interaction of triggers and constraints | |
| T211-08 | Active database, Enhanced integrity management | Multiple triggers for the same event are executed in the order in which they were created in the catalog | intentionally omitted |
| T251 | | SET TRANSACTION statement: LOCAL option | |
| T261 | | Chained transactions | |
| T272 | | Enhanced savepoint management | |
| T281 | | SELECT privilege with column granularity | |
| T301 | | Functional dependencies | |
| T321 | Core | Basic SQL-invoked routines | |
| T321-02 | Core | User-defined stored procedures with no overloading | |
| T321-04 | Core | CALL statement | |
| T321-05 | Core | RETURN statement | |
| T324 | | Explicit security for SQL routines | |
| T325 | | Qualified SQL parameter references | |
| T326 | | Table functions | |
| T331 | | Basic roles | |
| T332 | | Extended roles | |
| T401 | | INSERT into a cursor | |
| T411 | | UPDATE statement: SET ROW option | |
| T431 | OLAP | Extended grouping capabilities | |
| T432 | | Nested and concatenated GROUPING SETS | |
| T433 | | Multiargument GROUPING function | |
| T434 | | GROUP BY DISINCT | |
| T461 | | Symmetric BETWEEN predicate | |
| T471 | | Result sets return value | |
| T491 | | LATERAL derived table | |
| T511 | | Transaction counts | |
| T541 | | Updatable table references | |
| T561 | | Holdable locators | |
| T571 | | Array-returning external SQL-invoked functions | |
| T572 | | Multiset-returning external SQL-invoked functions | |
| T601 | | Local cursor references | |
| T611 | OLAP | Elementary OLAP operations | |
| T612 | | Advanced OLAP operations | |
| T613 | | Sampling | |
| T621 | | Enhanced numeric functions | |
| T631 | Core | IN predicate with one list element | |
| T641 | | Multiple column assignment | |
| T651 | | SQL-schema statements in SQL routines | |
| T652 | | SQL-dynamic statements in SQL routines | |
| T653 | | SQL-schema statements in external routines | |
| T654 | | SQL-dynamic statements in external routines | |
| T655 | | Cyclically dependent routines | |
