To create, modify or drop a database object like a table or view
you use the execute() method.
execute is similar to the
executeQuery() used to issue a select,
however it doesn't return a result.
Example 5-3. Drop Table Example
This example will drop a table.
Statement st = db.createStatement();
ResultSet rs = st.executeQuery("DROP TABLE mytable");
st.close();