To create, modify or drop a database object like a table or view
you use the execute() method. This method is
similar to the method executeQuery(), but it
doesn't return a result. Example 5.4, “Dropping a Table in JDBC”
illustrates the usage.
Example 5.4. Dropping a Table in JDBC
This example will drop a table.
Statement st = conn.createStatement();
st.execute("DROP TABLE mytable");
st.close();