SQL Tutorial


SQL CREATE TABLE
SQL DROP TABLE
SQL TRUNCATE TABLE
SQL INSERT INTO
SQL UPDATE
SQL DELETE FROM







Data Warehousing & Business Intelligence
Area Codes Info
State Info
HTML Tutorial







Home
SQL Commands
Table Manipulation
SQL Syntax

SQL DROP TABLE

Sometimes we may decide that we need to get rid of a table in the database for some reason. In fact, it would be problematic if we cannot do so because this could create a maintenance nightmare for the DBA's. Fortunately, SQL allows us to do it, as we can use the DROP TABLE command. The syntax for DROP TABLE is

DROP TABLE "table_name"

So, if we wanted to drop the table called customer that we created in the last section, we simply type

DROP TABLE customer.

Next Section

Site Map   |   Resources

1