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

Log in to the Orchestrator client as a user who can run JDBC workflows.

1

Click the Workflows view in the Orchestrator client.

2

In the workflows hierarchical list, open 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.

a

Type a password to access the database.

b

Type a database connection URL.

c

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.