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. |