App/Information
schema/Sql
features
Sql_features
Feature
ID
Feature Name
Sub Feature ID
Sub
Featur…
Sub Feature Name
Is
Supported
Is Verified By
Is
Verifie…
Comments
B011
Embedded Ada
—
—
NO
—
—
B012
Embedded C
—
—
YES
—
—
B013
Embedded COBOL
—
—
NO
—
—
B014
Embedded Fortran
—
—
NO
—
—
B015
Embedded MUMPS
—
—
NO
—
—
B016
Embedded Pascal
—
—
NO
—
—
B017
Embedded PL/I
—
—
NO
—
—
B021
Direct SQL
—
—
YES
—
—
B030
Enhanced dynamic SQL
—
—
NO
—
—
B031
Basic dynamic SQL
—
—
NO
—
—
B032
Extended dynamic SQL
—
—
NO
—
—
B033
Untyped SQL-invoked function arguments
—
—
NO
—
—
B034
Dynamic specification of cursor attributes
—
—
NO
—
—
B035
Non-extended descriptor names
—
—
NO
—
—
B036
Describe input statement
—
—
NO
—
—
Rows 1–15 of 500
‹
1
2
…
20
›
B041
Extensions to embedded SQL exception
declarations
—
—
NO
—
—
B051
Enhanced execution rights
—
—
NO
—
—
B111
Module language Ada
—
—
NO
—
—
B112
Module language C
—
—
NO
—
—
B113
Module language COBOL
—
—
NO
—
—
B114
Module language Fortran
—
—
NO
—
—
B115
Module language MUMPS
—
—
NO
—
—
B116
Module language Pascal
—
—
NO
—
—
B117
Module language PL/I
—
—
NO
—
—
B121
Routine language Ada
—
—
NO
—
—
B122
Routine language C
—
—
NO
—
—
B123
Routine language COBOL
—
—
NO
—
—
B124
Routine language Fortran
—
—
NO
—
—
B125
Routine language MUMPS
—
—
NO
—
—
B126
Routine language Pascal
—
—
NO
—
—
Rows 16–30 of 500
‹
1
2
3
…
20
›
B127
Routine language PL/I
—
—
NO
—
—
B128
Routine language SQL
—
—
YES
—
—
B200
Polymorphic table functions
—
—
NO
—
—
B201
More than one PTF generic table parameter
—
—
NO
—
—
B202
PTF copartitioning
—
—
NO
—
—
B203
More than one copartition specification
—
—
NO
—
—
B204
PRUNE WHEN EMPTY
—
—
NO
—
—
B205
Pass-through columns
—
—
NO
—
—
B206
PTF descriptor parameters
—
—
NO
—
—
B207
Cross products of partitionings
—
—
NO
—
—
B208
PTF component procedure interface
—
—
NO
—
—
B209
PTF extended names
—
—
NO
—
—
B211
Module language Ada: VARCHAR and
NUMERIC support
—
—
NO
—
—
B221
Routine language Ada: VARCHAR and
NUMERIC support
—
—
NO
—
—
E011
Numeric data types
—
—
YES
—
—
Rows 31–45 of 500
‹
1
2
3
4
…
20
›
E011
Numeric data types
1
INTEGER and SMALLINT data types
YES
—
—
E011
Numeric data types
2
REAL, DOUBLE PRECISION, and
FLOAT data types
YES
—
—
E011
Numeric data types
3
DECIMAL and NUMERIC data types
YES
—
—
E011
Numeric data types
4
Arithmetic operators
YES
—
—
E011
Numeric data types
5
Numeric comparison
YES
—
—
E011
Numeric data types
6
Implicit casting among the numeric
data types
YES
—
—
E021
Character data types
—
—
YES
—
—
E021
Character string types
1
CHARACTER data type
YES
—
—
E021
Character string types
2
CHARACTER VARYING data type
YES
—
—
E021
Character string types
3
Character literals
YES
—
—
E021
Character string types
4
CHARACTER_LENGTH function
YES
—
trims
trailing
spaces
from
CHARACTE
R values
before
counting
E021
Character string types
5
OCTET_LENGTH function
YES
—
—
E021
Character string types
6
SUBSTRING function
YES
—
—
E021
Character string types
7
Character concatenation
YES
—
—
E021
Character string types
8
UPPER and LOWER functions
YES
—
—
Rows 46–60 of 500
‹
1
…
3
4
5
…
20
›
E021
Character string types
9
TRIM function
YES
—
—
E021
Character string types
10
Implicit casting among the
character string types
YES
—
—
E021
Character string types
11
POSITION function
YES
—
—
E021
Character string types
12
Character comparison
YES
—
—
E031
Identifiers
—
—
YES
—
—
E031
Identifiers
1
Delimited identifiers
YES
—
—
E031
Identifiers
2
Lower case identifiers
YES
—
—
E031
Identifiers
3
Trailing underscore
YES
—
—
E051
Basic query specification
—
—
YES
—
—
E051
Basic query specification
1
SELECT DISTINCT
YES
—
—
E051
Basic query specification
2
GROUP BY clause
YES
—
—
E051
Basic query specification
4
GROUP BY can contain columns not
in <select list>
YES
—
—
E051
Basic query specification
5
Select list items can be renamed
YES
—
—
E051
Basic query specification
6
HAVING clause
YES
—
—
E051
Basic query specification
7
Qualified * in select list
YES
—
—
Rows 61–75 of 500
‹
1
…
4
5
6
…
20
›
E051
Basic query specification
8
Correlation names in the FROM
clause
YES
—
—
E051
Basic query specification
9
Rename columns in the FROM
clause
YES
—
—
E061
Basic predicates and search conditions
—
—
YES
—
—
E061
Basic predicates and search conditions
1
Comparison predicate
YES
—
—
E061
Basic predicates and search conditions
2
BETWEEN predicate
YES
—
—
E061
Basic predicates and search conditions
3
IN predicate with list of values
YES
—
—
E061
Basic predicates and search conditions
4
LIKE predicate
YES
—
—
E061
Basic predicates and search conditions
5
LIKE predicate ESCAPE clause
YES
—
—
E061
Basic predicates and search conditions
6
NULL predicate
YES
—
—
E061
Basic predicates and search conditions
7
Quantified comparison predicate
YES
—
—
E061
Basic predicates and search conditions
8
EXISTS predicate
YES
—
—
E061
Basic predicates and search conditions
9
Subqueries in comparison
predicate
YES
—
—
E061
Basic predicates and search conditions
11
Subqueries in IN predicate
YES
—
—
E061
Basic predicates and search conditions
12
Subqueries in quantified
comparison predicate
YES
—
—
E061
Basic predicates and search conditions
13
Correlated subqueries
YES
—
—
Rows 76–90 of 500
‹
1
…
5
6
7
…
20
›
E061
Basic predicates and search conditions
14
Search condition
YES
—
—
E071
Basic query expressions
—
—
YES
—
—
E071
Basic query expressions
1
UNION DISTINCT table operator
YES
—
—
E071
Basic query expressions
2
UNION ALL table operator
YES
—
—
E071
Basic query expressions
3
EXCEPT DISTINCT table operator
YES
—
—
E071
Basic query expressions
5
Columns combined via table
operators need not have exactly the
same data type
YES
—
—
E071
Basic query expressions
6
Table operators in subqueries
YES
—
—
E081
Basic Privileges
—
—
YES
—
—
E081
Basic Privileges
1
SELECT privilege
YES
—
—
E081
Basic Privileges
2
DELETE privilege
YES
—
—
E081
Basic Privileges
3
INSERT privilege at the table level
YES
—
—
E081
Basic Privileges
4
UPDATE privilege at the table level
YES
—
—
E081
Basic Privileges
5
UPDATE privilege at the column
level
YES
—
—
E081
Basic Privileges
6
REFERENCES privilege at the table
level
YES
—
—
E081
Basic Privileges
7
REFERENCES privilege at the
column level
YES
—
—
Rows 91–105 of 500
‹
1
…
6
7
8
…
20
›
E081
Basic Privileges
8
WITH GRANT OPTION
YES
—
—
E081
Basic Privileges
9
USAGE privilege
YES
—
—
E081
Basic Privileges
10
EXECUTE privilege
YES
—
—
E091
Set functions
—
—
YES
—
—
E091
Set functions
1
AVG
YES
—
—
E091
Set functions
2
COUNT
YES
—
—
E091
Set functions
3
MAX
YES
—
—
E091
Set functions
4
MIN
YES
—
—
E091
Set functions
5
SUM
YES
—
—
E091
Set functions
6
ALL quantifier
YES
—
—
E091
Set functions
7
DISTINCT quantifier
YES
—
—
E101
Basic data manipulation
—
—
YES
—
—
E101
Basic data manipulation
1
INSERT statement
YES
—
—
E101
Basic data manipulation
3
Searched UPDATE statement
YES
—
—
E101
Basic data manipulation
4
Searched DELETE statement
YES
—
—
Rows 106–120 of 500
‹
1
…
7
8
9
…
20
›
E111
Single row SELECT statement
—
—
YES
—
—
E121
Basic cursor support
—
—
YES
—
—
E121
Basic cursor support
1
DECLARE CURSOR
YES
—
—
E121
Basic cursor support
2
ORDER BY columns need not be in
select list
YES
—
—
E121
Basic cursor support
3
Value expressions in ORDER BY
clause
YES
—
—
E121
Basic cursor support
4
OPEN statement
YES
—
—
E121
Basic cursor support
6
Positioned UPDATE statement
YES
—
—
E121
Basic cursor support
7
Positioned DELETE statement
YES
—
—
E121
Basic cursor support
8
CLOSE statement
YES
—
—
E121
Basic cursor support
10
FETCH statement implicit NEXT
YES
—
—
E121
Basic cursor support
17
WITH HOLD cursors
YES
—
—
E131
Null value support (nulls in lieu of values)
—
—
YES
—
—
E141
Basic integrity constraints
—
—
YES
—
—
E141
Basic integrity constraints
1
NOT NULL constraints
YES
—
—
E141
Basic integrity constraints
2
UNIQUE constraints of NOT NULL
columns
YES
—
—
Rows 121–135 of 500
‹
1
…
8
9
10
…
20
›
E141
Basic integrity constraints
3
PRIMARY KEY constraints
YES
—
—
E141
Basic integrity constraints
4
Basic FOREIGN KEY constraint with
the NO ACTION default for both
referential delete action and
referential update action
YES
—
—
E141
Basic integrity constraints
6
CHECK constraints
YES
—
—
E141
Basic integrity constraints
7
Column defaults
YES
—
—
E141
Basic integrity constraints
8
NOT NULL inferred on PRIMARY
KEY
YES
—
—
E141
Basic integrity constraints
10
Names in a foreign key can be
specified in any order
YES
—
—
E151
Transaction support
—
—
YES
—
—
E151
Transaction support
1
COMMIT statement
YES
—
—
E151
Transaction support
2
ROLLBACK statement
YES
—
—
E152
Basic SET TRANSACTION statement
—
—
YES
—
—
E152
Basic SET TRANSACTION statement
1
SET TRANSACTION statement:
ISOLATION LEVEL SERIALIZABLE
clause
YES
—
—
E152
Basic SET TRANSACTION statement
2
SET TRANSACTION statement:
READ ONLY and READ WRITE
clauses
YES
—
—
E153
Updatable queries with subqueries
—
—
YES
—
—
E161
SQL comments using leading double minus
—
—
YES
—
—
E171
SQLSTATE support
—
—
YES
—
—
Rows 136–150 of 500
‹
1
…
9
10
11
…
20
›
E182
Host language binding
—
—
YES
—
—
F021
Basic information schema
—
—
YES
—
—
F021
Basic information schema
1
COLUMNS view
YES
—
—
F021
Basic information schema
2
TABLES view
YES
—
—
F021
Basic information schema
3
VIEWS view
YES
—
—
F021
Basic information schema
4
TABLE_CONSTRAINTS view
YES
—
—
F021
Basic information schema
5
REFERENTIAL_CONSTRAINTS view
YES
—
—
F021
Basic information schema
6
CHECK_CONSTRAINTS view
YES
—
—
F031
Basic schema manipulation
—
—
YES
—
—
F031
Basic schema manipulation
1
CREATE TABLE statement to create
persistent base tables
YES
—
—
F031
Basic schema manipulation
2
CREATE VIEW statement
YES
—
—
F031
Basic schema manipulation
3
GRANT statement
YES
—
—
F031
Basic schema manipulation
4
ALTER TABLE statement: ADD
COLUMN clause
YES
—
—
F031
Basic schema manipulation
13
DROP TABLE statement: RESTRICT
clause
YES
—
—
F031
Basic schema manipulation
16
DROP VIEW statement: RESTRICT
clause
YES
—
—
Rows 151–165 of 500
‹
1
…
10
11
12
…
20
›
F031
Basic schema manipulation
19
REVOKE statement: RESTRICT
clause
YES
—
—
F032
CASCADE drop behavior
—
—
YES
—
—
F033
ALTER TABLE statement: DROP COLUMN
clause
—
—
YES
—
—
F034
Extended REVOKE statement
—
—
YES
—
—
F035
REVOKE with CASCADE
—
—
YES
—
—
F036
REVOKE statement performed by non-owner
—
—
YES
—
—
F037
REVOKE statement: GRANT OPTION FOR
clause
—
—
YES
—
—
F038
REVOKE of a WITH GRANT OPTION privilege
—
—
YES
—
—
F041
Basic joined table
—
—
YES
—
—
F041
Basic joined table
1
Inner join (but not necessarily the
INNER keyword)
YES
—
—
F041
Basic joined table
2
INNER keyword
YES
—
—
F041
Basic joined table
3
LEFT OUTER JOIN
YES
—
—
F041
Basic joined table
4
RIGHT OUTER JOIN
YES
—
—
F041
Basic joined table
5
Outer joins can be nested
YES
—
—
F041
Basic joined table
7
The inner table in a left or right
outer join can also be used in an
inner join
YES
—
—
Rows 166–180 of 500
‹
1
…
11
12
13
…
20
›
F041
Basic joined table
8
All comparison operators are
supported (rather than just =)
YES
—
—
F051
Basic date and time
—
—
YES
—
—
F051
Basic date and time
1
DATE data type (including support
of DATE literal)
YES
—
—
F051
Basic date and time
2
TIME data type (including support
of TIME literal) with fractional
seconds precision of at least 0
YES
—
—
F051
Basic date and time
3
TIMESTAMP data type (including
support of TIMESTAMP literal) with
fractional seconds precision of at
least 0 and 6
YES
—
—
F051
Basic date and time
4
Comparison predicate on DATE,
TIME, and TIMESTAMP data types
YES
—
—
F051
Basic date and time
5
Explicit CAST between datetime
types and character string types
YES
—
—
F051
Basic date and time
6
CURRENT_DATE
YES
—
—
F051
Basic date and time
7
LOCALTIME
YES
—
—
F051
Basic date and time
8
LOCALTIMESTAMP
YES
—
—
F052
Intervals and datetime arithmetic
—
—
YES
—
—
F053
OVERLAPS predicate
—
—
YES
—
—
F054
TIMESTAMP in DATE type precedence list
—
—
NO
—
—
F081
UNION and EXCEPT in views
—
—
YES
—
—
F111
Isolation levels other than SERIALIZABLE
—
—
YES
—
—
Rows 181–195 of 500
‹
1
…
12
13
14
…
20
›
F112
Isolation level READ UNCOMMITTED
—
—
YES
—
—
F113
Isolation level READ COMMITTED
—
—
YES
—
—
F114
Isolation level REPEATABLE READ
—
—
YES
—
—
F120
Get diagnostics statement
—
—
NO
—
—
F121
Basic diagnostics management
—
—
NO
—
—
F122
Enhanced diagnostics management
—
—
NO
—
—
F123
All diagnostics
—
—
NO
—
—
F124
SET TRANSACTION statement: DIAGNOSTICS
SIZE clause
—
—
NO
—
—
F131
Grouped operations
—
—
YES
—
—
F131
Grouped operations
1
WHERE, GROUP BY, and HAVING
clauses supported in queries with
grouped views
YES
—
—
F131
Grouped operations
2
Multiple tables supported in queries
with grouped views
YES
—
—
F131
Grouped operations
3
Set functions supported in queries
with grouped views
YES
—
—
F131
Grouped operations
4
Subqueries with GROUP BY and
HAVING clauses and grouped
views
YES
—
—
F131
Grouped operations
5
Single row SELECT with GROUP BY
and HAVING clauses and grouped
views
YES
—
—
F171
Multiple schemas per user
—
—
YES
—
—
Rows 196–210 of 500
‹
1
…
13
14
15
…
20
›
F181
Multiple module support
—
—
YES
—
—
F191
Referential delete actions
—
—
YES
—
—
F200
TRUNCATE TABLE statement
—
—
YES
—
—
F201
CAST function
—
—
YES
—
—
F202
TRUNCATE TABLE: identity column restart
option
—
—
YES
—
—
F221
Explicit defaults
—
—
YES
—
—
F222
INSERT statement: DEFAULT VALUES clause
—
—
YES
—
—
F231
Privilege tables
—
—
YES
—
—
F251
Domain support
—
—
YES
—
—
F261
CASE expression
—
—
YES
—
—
F261
CASE expression
1
Simple CASE
YES
—
—
F261
CASE expression
2
Searched CASE
YES
—
—
F261
CASE expression
3
NULLIF
YES
—
—
F261
CASE expression
4
COALESCE
YES
—
—
F262
Extended CASE expression
—
—
YES
—
—
Rows 211–225 of 500
‹
1
…
14
15
16
…
20
›
F263
Comma-separated predicates in simple CASE
expression
—
—
NO
—
—
F271
Compound character literals
—
—
YES
—
—
F281
LIKE enhancements
—
—
YES
—
—
F291
UNIQUE predicate
—
—
NO
—
—
F292
UNIQUE null treatment
—
—
YES
—
—
F301
CORRESPONDING in query expressions
—
—
NO
—
—
F302
INTERSECT table operator
—
—
YES
—
—
F303
INTERSECT DISTINCT table operator
—
—
YES
—
—
F304
EXCEPT ALL table operator
—
—
YES
—
—
F305
INTERSECT ALL table operator
—
—
YES
—
—
F311
Schema definition statement
—
—
YES
—
—
F311
Schema definition statement
1
CREATE SCHEMA
YES
—
—
F311
Schema definition statement
2
CREATE TABLE for persistent base
tables
YES
—
—
F311
Schema definition statement
3
CREATE VIEW
YES
—
—
F311
Schema definition statement
4
CREATE VIEW: WITH CHECK
OPTION
YES
—
—
Rows 226–240 of 500
‹
1
…
15
16
17
…
20
›
F311
Schema definition statement
5
GRANT statement
YES
—
—
F312
MERGE statement
—
—
YES
—
—
F313
Enhanced MERGE statement
—
—
YES
—
—
F314
MERGE statement with DELETE branch
—
—
YES
—
—
F321
User authorization
—
—
YES
—
—
F341
Usage tables
—
—
YES
—
—
F361
Subprogram support
—
—
YES
—
—
F381
Extended schema manipulation
—
—
YES
—
—
F382
Alter column data type
—
—
YES
—
—
F383
Set column not null clause
—
—
YES
—
—
F384
Drop identity property clause
—
—
YES
—
—
F385
Drop column generation expression clause
—
—
YES
—
—
F386
Set identity column generation clause
—
—
YES
—
—
F387
ALTER TABLE statement: ALTER COLUMN
clause
—
—
YES
—
—
F388
ALTER TABLE statement: ADD/DROP
CONSTRAINT clause
—
—
YES
—
—
Rows 241–255 of 500
‹
1
…
16
17
18
…
20
›
F391
Long identifiers
—
—
YES
—
—
F392
Unicode escapes in identifiers
—
—
YES
—
—
F393
Unicode escapes in literals
—
—
YES
—
—
F394
Optional normal form specification
—
—
YES
—
—
F401
Extended joined table
—
—
YES
—
—
F402
Named column joins for LOBs, arrays, and
multisets
—
—
YES
—
—
F403
Partitioned join tables
—
—
NO
—
—
F404
Range variable for common column names
—
—
YES
—
—
F405
NATURAL JOIN
—
—
YES
—
—
F406
FULL OUTER JOIN
—
—
YES
—
—
F407
CROSS JOIN
—
—
YES
—
—
F411
Time zone specification
—
—
YES
—
differences
regarding
literal
interpretati
on
F421
National character
—
—
YES
—
—
F431
Read-only scrollable cursors
—
—
YES
—
—
F432
FETCH with explicit NEXT
—
—
YES
—
—
Rows 256–270 of 500
‹
1
…
17
18
19
20
›
F433
FETCH FIRST
—
—
YES
—
—
F434
FETCH LAST
—
—
YES
—
—
F435
FETCH PRIOR
—
—
YES
—
—
F436
FETCH ABSOLUTE
—
—
YES
—
—
F437
FETCH RELATIVE
—
—
YES
—
—
F438
Scrollable cursors
—
—
YES
—
—
F441
Extended set function support
—
—
YES
—
—
F442
Mixed column references in set functions
—
—
YES
—
—
F451
Character set definition
—
—
NO
—
—
F461
Named character sets
—
—
NO
—
—
F471
Scalar subquery values
—
—
YES
—
—
F481
Expanded NULL predicate
—
—
YES
—
—
F491
Constraint management
—
—
YES
—
—
F492
Optional table constraint enforcement
—
—
NO
—
—
F501
Features and conformance views
—
—
YES
—
—
Rows 271–285 of 500
‹
1
…
18
19
20
›
F501
Features and conformance views
1
SQL_FEATURES view
YES
—
—
F501
Features and conformance views
2
SQL_SIZING view
YES
—
—
F502
Enhanced documentation tables
—
—
YES
—
—
F521
Assertions
—
—
NO
—
—
F531
Temporary tables
—
—
YES
—
—
F555
Enhanced seconds precision
—
—
YES
—
—
F561
Full value expressions
—
—
YES
—
—
F571
Truth value tests
—
—
YES
—
—
F591
Derived tables
—
—
YES
—
—
F611
Indicator data types
—
—
YES
—
—
F641
Row and table constructors
—
—
YES
—
—
F651
Catalog name qualifiers
—
—
YES
—
—
F661
Simple tables
—
—
YES
—
—
F671
Subqueries in CHECK constraints
—
—
NO
—
intentionall
y omitted
F672
Retrospective CHECK constraints
—
—
YES
—
—
Rows 286–300 of 500
‹
1
…
19
20
›
Showing pages 1–20 of 34 in this static export
Data as of 07:07 UTC on 26 Oct 2026
made with
dbt Charts