This section describes how to drop a table in the current database.
Sometimes you need to drop a table from the database. Dropping a table means deleting all rows of data in the table
and also deleting the table definition. The following Java sample program shows you how to drop the table named "Price":
/**
* DropTable.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class DropTable {
public static void main(String [] args) {
Connection con = null;
try {
Class.forName(
"com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection(
"jdbc:sqlserver://localhost:1269;"
+ "user=sa;password=HerongYang;"
+ "database=AdventureWorksLT");
// Adding a new column to an existing table
Statement sta = con.createStatement();
sta.executeUpdate("DROP TABLE Herong.Price");
System.out.println("Table dropped.");
sta.executeQuery("SELECT * FROM Herong.Price");
sta.close();
con.close();
} catch (java.lang.ClassNotFoundException e) {
System.err.println("ClassNotFoundException: "
+e.getMessage());
} catch (SQLException e) {
System.err.println("SQLException: "
+e.getMessage());
}
}
}
The output of this program has a SQLException showing us that the table is gone:
Table dropped.
SQLException: Invalid object name 'Herong.Price'.
