Basic information schema
Derby Reference Manual
214
Feature
Source
Derby
DESCRIBE output
SQL92T
Yes, by using JDBC
method calls
Table 25.
Support for SQL-92 features: Basic information schema
Feature
Source
Derby
TABLES
SQL92T
SYS.SYSTABLES,
SYS.SYSVIEWS,
SYS.SYSCOLUMNS
VIEWS
SQL92T
SYS.SYSTABLES,
SYS.SYSVIEWS,
SYS.SYSCOLUMNS
COLUMNS
SQL92T
SYS.SYSTABLES,
SYS.SYSVIEWS,
SYS.SYSCOLUMNS
Table 26.
Support for SQL-92 features: Basic schema manipulation
Feature
Source
Derby
CREATE / DROP TABLE
SQL92T
Yes
CREATE / DROP VIEW
SQL92T
Yes
GRANT / REVOKE
SQL92T
Yes
ALTER TABLE ADD COLUMN
SQL92T
Yes
ALTER TABLE DROP COLUMN
SQL92T
Yes
Table 27.
Support for SQL-92 features: Joined table
Feature
Source
Derby
INNER JOIN
SQL92T
Yes
natural join
SQL92T
No
LEFT, RIGHT OUTER JOIN
SQL92T
Yes
join condition
SQL92T
Yes
named columns join
SQL92T
Yes
Table 28.
Support for SQL-92 features: Date and time data types
Feature
Source
Derby
simple DATE, TIME,
TIMESTAMP, INTERVAL
SQL92T
Yes, not INTERVAL
datetime constants
SQL92T
Yes
datetime math
SQL92T
Yes, with Java methods
datetime comparisons
SQL92T
Yes
