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

Before you begin

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

Procedure

  1. Click the Workflows view in the Orchestrator client.
  2. In the workflows hierarchical list, expand Library > JDBC > JDBC Examples to navigate to the JDBC drop table example workflow.
  3. Right-click the JDBC drop table example workflow and select Start workflow.
  4. Provide the required information, and click Next.
    1. Type a password to access the database.
    2. Type a database connection URL.
    3. Type a user name to access the database.
  5. Type an SQL drop statement.

    An example syntax is:

    DROP TABLE "table_name"
  6. Click Submit to run the workflow.