SQLSCRIPT_LOGGING_TABLE_TYPE

SQLSCRIPT_LOGGING:LOG 只能将日志写入具有预定义表类型的表。您可以使用类型 SYS.SQLSCRIPT_LOGGING_TABLE_TYPE 或公共同义词 SQLSCRIPT_LOGGING_TABLE_TYPE 创建输出表。

定义

CREATE TYPE SYS.SQLSCRIPT_LOGGING_TABLE_TYPE AS TABLE ( HOST VARCHAR(64) NOT NULL, PORT INTEGER NOT NULL, THREAD_ID BIGINT NOT NULL,
    CONNECTION_ID INTEGER NOT NULL, TRANSACTION_ID INTEGER NOT NULL, TIMESTAMP TIMESTAMP NOT NULL, LEVEL VARCHAR(7) NOT NULL, USER_NAME NVARCHAR(256) NOT NULL, TOPIC VARCHAR(32) NOT NULL,
    DATABASE_NAME NVARCHAR(256), SCHEMA_NAME NVARCHAR(256), OBJECT_NAME NVARCHAR(256), MEMBER_NAME NVARCHAR(256),
    SOURCE_LINE INTEGER NOT NULL, MESSAGE NVARCHAR(5000));
 
CREATE PUBLIC SYNONYM SQLSCRIPT_LOGGING_TABLE_TYPE FOR SYS.SQLSCRIPT_LOGGING_TABLE_TYPE;

示例

示例代码create table mytab like sys.sqlscript_logging_table_type;