DROP_SCHEMA_ON_SOURCE¶

Description

The stored procedure DROP_SCHEMA_ON_SOURCE removes a schema on the specified data source.

If you want to create a new schema, check the procedure CREATE_SCHEMA_ON_SOURCE.

Syntax

DROP_SCHEMA_ON_SOURCE (
      database_name : varchar
    , datasource_name : varchar
    , catalog : varchar
    , schema : varchar
)

Note

Currently, this feature is only supported for the Denodo Embedded MPP data source and PrestoDB data sources.

The procedure returns this field:

procedure_status: Success if the procedure executed correctly, Failure otherwise.

Privileges Required

The user that executes this procedure must have at least WRITE and EXECUTE privileges on the targeted data source.

Example

CALL DROP_SCHEMA_ON_SOURCE('admin_denodo_mpp', 'admin_denodo_mpp', 'hive', 'test');

Deletes the schema test on the catalog hive of the data source admin_denodo_mpp.

USER MANUALS