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. The example below show you how to do it in MySQL database.
package org.kodejava.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class DropTableExample {
private static final String URL = "jdbc:mysql://localhost/kodejava";
private static final String USERNAME = "kodejava";
private static final String PASSWORD = "s3cr*t";
public static void main(String[] args) {
try (Connection connection =
DriverManager.getConnection(URL, USERNAME, PASSWORD)) {
// To delete a table from database we use the DROP TABLE
// command and specify the table name to be dropped
String sql = "DROP TABLE IF EXISTS book";
// Create a statement
Statement statement = connection.createStatement();
// Execute the statement to delete the table
statement.execute(sql);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
Maven Dependencies
<dependency>
<groupId>com.mysql</groupId>
<artifactId>mysql-connector-j</artifactId>
<version>8.1.0</version>
</dependency>
Latest posts by Wayan (see all)
- How do I iterate through date range in Java? - October 5, 2023
- How do I create a string of repeated characters? - September 1, 2023
- How do I convert datetime string with optional part to a date object? - August 28, 2023