TRUNCATED_SCHEMATA

Lists the original names of restored schemas that were truncated due to name lengths exceeding 128 characters.

Column Name Data Type Description
RESTORE_TIME
TIMESTAMPZ The time that the table was restored.
SESSION_ID
VARCHAR Identifier for the restoring session. This identifier is unique within the cluster at any point in time but can be reused when the session closes.
USER_ID
INTEGER Identifier of the user for the restore event.
USER_NAME
VARCHAR Name of the user for which Vertica lists restore information at the time it recorded the session.
TRANSACTION_ID
INTEGER Identifier for the transaction within the session, if any; otherwise NULL.
ORIGINAL_SCHEMA_NAME
VARCHAR The original name of the schema prior to the restore.
NEW_SCHEMA_NAME
VARCHAR The name of the schema after it was truncated.

Privileges

None