"DROP TABLE" Statements

JDBC for SQL Server - Herong's Tutorial Examples

∟"DROP TABLE" Statements

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) HerongYang.com. All Rights Reserved.
 */
import java.sql.*;
public class DropTable {
  public static void main(String [] args) {
    Connection con = null;
    try {

      con = DriverManager.getConnection(
          "jdbc:sqlserver://localhost\\SQLEXPRESS;"
        + "user=herong;password=T0pSecret;"
        + "database=AdventureWorks2019");

// 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 (Exception e) {
      e.printStackTrace();
    }
  }
}

The output of this program has a SQLException showing us that the table is gone:

herong> java -cp .;mssql-jdbc-9.4.1.jre16.jar DropTable.java

Table dropped.
com.microsoft.sqlserver.jdbc.SQLServerException:
Invalid object name 'Herong.Price'.