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.
execute()
executeQuery()
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();