SYSSTATEMENTS system table

Contains one row per stored prepared statement.
Column Name Type Length Nullability Contents
STMTID CHAR 36 false unique identifier for the statement
STMTNAME VARCHAR 128 false name of the statement
SCHEMAID CHAR 36 false the schema in which the statement resides
TYPE CHAR 1 false always 'S'
VALID BOOLEAN   false TRUE if valid, FALSE if invalid
TEXT LONG VARCHAR   false text of the statement
LASTCOMPILED TIMESTAMP   true time that the statement was compiled
COMPILATION SCHEMAID CHAR 36 false id of the schema containing the statement
USINGTEXT LONG VARCHAR   true text of the USING clause of the CREATE STATEMENT and ALTER STATEMENT statements
Parent topic: Derby system tables