Drop a JDBC Table

You can run a workflow from the vRealize Orchestrator Client to test the dropping of a JDBC table.

Prerequisites

Verify that the user account you are logged in with has the necessary permissions to run JDBC workflows.

Procedure

1. Navigate to Library > Workflows and enter the jdbc_examples tag in the workflow search box.
2. Locate the JDBC drop table example workflow and click Run.
3. Provide the required information.
   1. Type a password to access the database.
   2. Type a database connection URL.
   3. Type a user name to access the database.
4. Enter an SQL drop statement similar to the following example syntax.

   DROP TABLE "table_name"

5. Click Run.