SHOW DDL RESULT

You can execute the SHOW DDL RESULT statement to view the results of DDL jobs that are recently executed.

Syntax

SHOW DDL RESULT;

Examples

SHOW DDL RESULT\G;
*************************** 1. row ***************************
        JOB_ID: 1359590227445809152
   SCHEMA_NAME: test
   OBJECT_NAME: test_table
      DDL_TYPE: CREATE_TABLE
   RESULT_TYPE: SUCCESS
RESULT_CONTENT: SUCCESS
1 row in set (0 min 0.83 sec)

Response parameters

Parameter Description
JOB_ID The unique ID of the DDL job. The ID is a 64-bit signed integer of the LONG data type.
SCHEMA_NAME The schema name of the object on which the DDL job is performed.
OBJECT_NAME The name of the object on which the DDL job is performed. For example, the value can be the name of the table on which the DDL statement is executed.
DDL_TYPE The type of the DDL job. Example: CREATE_TABLE.
RESULT_TYPE The type of the execution result of the DDL job.
RESULT_CONTENT The details about the execution result of the DDL job.

results matching ""

    No results matching ""