Creating and Modifying Database Objects

5.5. Creating and Modifying Database Objects

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();

© Copyright 2003-2023 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.