DROP RESOURCE

    Syntax

    • DROP RESOURCE will only drop resources in Proxy, the real data source corresponding to the resource will not be dropped;
    • Unable to drop resources already used by rules. Resources are still in used. will be prompted when removing resources used by rules;
    • The resource need to be removed only contains SINGLE TABLE RULE, and when the user confirms that this restriction can be ignored, the keyword can be added to remove the resource.

    Example

    • Drop multiple resources
    • Ignore single table rule remove resource
    • Drop the resource if it exists

    DROP, RESOURCE, IF, , IGNORE, SINGLE, TABLES