Documentation schema
Derby Reference Manual
216
Feature
Source
Derby
SET SESSION
AUTHORIZATION
SQL92I
Use SET SCHEMA
CURRENT_USER
SQL92I
Yes
SESSION_USER
SQL92I
Yes
SYSTEM_USER
SQL92I
No
Table 36.
Support for SQL-92 features: Constraint tables
Feature
Source
Derby
TABLE CONSTRAINTS
SQL92I
SYS.SYSCONSTRAINTS
REFERENTIAL CONSTRAINTS
SQL92I
SYS.SYSFOREIGNKEYS
CHECK CONSTRAINTS
SQL92I
SYS.SYSCHECKS
Table 37.
Support for SQL-92 features: Documentation schema
Feature
Source
Derby
SQL_FEATURES
SQL92I/FIPS 127-2
Use JDBC
DatabaseMetaData
SQL_SIZING
SQL92I/FIPS 127-2
Use JDBC
DatabaseMetaData
Table 38.
Support for SQL-92 features: Full DATETIME
Feature
Source
Derby
precision for TIME and
TIMESTAMP
SQL92F
Yes
Table 39.
Support for SQL-92 features: Full character functions
Feature
Source
Derby
POSITION expression
SQL92F
Use Java methods or
LOCATE
UPPER/LOWER functions
SQL92F
Yes
Table 40.
Support for SQL-92 features: Miscellaneous
Feature
Source
Derby
Delimited identifiers
SQL92E
Yes
Correlated subqueries
SQL92E
Yes
Insert, Update, Delete statements
SQL92E
Yes
Joins
SQL92E
Yes
Where qualifications
SQL92E
Yes
