# SYSSTATEMENTS system table

The SYSSTATEMENTS table describes the prepared statements in the database.

The table contains one row per stored prepared statement.

The following table shows the contents of the SYSSTATEMENTS system table.

Table 1. SYSSTATEMENTS system table
Column Name | Type | Length | Nullable | 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 | 1 | false | Whether or not the statement is valid
TEXT | LONG VARCHAR | 32,700 | false | Text of the statement
LASTCOMPILED | TIMESTAMP | 29 | true | Time that the statement was compiled
COMPILATIONSCHEMAID | CHAR | 36 | true | ID of the schema containing the statement
USINGTEXT | LONG VARCHAR | 32,700 | true | Text of the USING clause of the CREATE STATEMENT and ALTER STATEMENT statements

Parent topic: Derby system tables