Removes an existing Cirro resource, which was added with the ADD RESOURCE command.

Syntax


DROP RESOURCE 'resource' FROM DRIVER driver;

Arguments

  • resource: The resource. Enclose in single quotes.

    • Use SELECT * FROM SYS.DRIVERRESOURCE to obtain the list of all current resources.
  • driver: An existing driver associated with the resource.

    • Use SELECT * FROM SYS.DRIVERS to obtain the list of all current drivers.

Examples


DROP RESOURCE 'ojdbc6.jar' FROM DRIVER oracle2;