Skip to main content

SHOW CREATE LOAD

Description​

This statement is used to display the creation statement of an import job.

Syntax​

SHOW CREATE LOAD FOR <load_name>;

Required Parameters​

<load_name>

The name of the routine import job.

Access Control Requirements​

Users executing this SQL command must have at least the following permissions:

PrivilegeObjectNotes
ADMIN/NODE_PRIVDatabaseCluster administrator privileges are required.

Return Value​

Returns the creation statement of the specified import job.

Examples​

  • Display the creation statement of the specified import job in the default database.
SHOW CREATE LOAD for test_load