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 8-3. Drop Table Example
This example will drop a table.
Statement st = db.createStatement(); ResultSet rs = st.executeQuery("DROP TABLE mytable"); st.close();