SYSSTATEMENTS system table The SYSSTATEMENTS table describes the prepared statements in the database. system tablesSYSSTATEMENTS statementsSYSSTATEMENTS system table prepared statementsSYSSTATEMENTS system table SYSSTATEMENTS system table

The table contains one row per stored prepared statement.

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

SYSSTATEMENTS system tableFor each column in the SYSSTATEMENTS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents. 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