How do I drop table from database?
Category: java.sql, viewed: 1626 time(s).
This example is to show you how to delete or drop a table from your database. Basically we just send a "drop table" command and specify the table name to be deleted to the database.
package org.kodejava.example.sql; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class DropTableExample { public static void main(String[] args) throws Exception { Connection connection = null; try { // This is the JDBC driver class for Oracle database Class.forName("oracle.jdbc.driver.OracleDriver"); // We use an Oracle express database for this example String url = "jdbc:oracle:thin:@localhost:1521:xe"; // Define the username and password for connection to // our database. String username = "kodejava"; String password = "welcome"; // To delete a table from database we use the DROP TABLE // command and specify the table name to be dropped String sql = "DROP TABLE books"; // Connect to database connection = DriverManager.getConnection(url, username, password); // Create a statement Statement statement = connection.createStatement(); // Execute the statement to delete the table statement.execute(sql); } catch (SQLException e) { e.printStackTrace(); } finally { if (connection != null && !connection.isClosed()) { connection.close(); } } } } |
Can't find what you are looking for? Join our FORUMS and ask some questions!
Related Examples
- How do I get system functions supported by database?
- How do I get date time functions supported by database?
- How do I get numeric functions supported by database?
- How do I get string functions supported by database?
- How do I get the max concurrent connection to a database?
- How do I get database maximum table name length?
- How do I know if database support updatable result sets?
- How do I know if database support scrollable result sets?
- How do I know if database support batch update?
- How do I get data types supported by database?
- How do I know if database support transaction?
- How do I get database product information?
- How do I get JDBC driver information?
- How do I get list of stored procedure names?
- How do I read CLOBs data from database?
- How do I store CLOBs data into database?
- How do I read BLOBs data from database?
- How do I store BLOBs data into database?
- How do I execute stored procedure?
- How do I make updates in Updatable ResultSet?
Most Viewed Examples
Latest Code Examples
Categories
100 Top & Latest
Latest Jobs
Blog Entries
Forums Entries
- Google Chrome
- Re: Importing and scanning the text
- Re: What Java books have you read?
- Re: How to create exe file
- How to create exe file
- Re: What Java books have you read?
- Infix expression
- Importing and scanning the text
- Re: I want to reduce the size of a JPG image
- MOVED: I want to reduce the size of a JPG image
