	SQL Tutorials
	SQL SELECT
	SQL DISTINCT
	SQL WHERE
	SQL AND OR
	SQL IN
	SQL BETWEEN
	SQL LIKE
	SQL ORDER BY
	SQL FUNCTIONS
	SQL COUNT
	SQL GROUP BY
	SQL HAVING
	SQL ALIAS
	SQL JOIN
	SQL OUTER JOIN
	SQL CONCATENATE
	SQL SUBSTRING
	SQL TRIM
	SQL CREATE TABLE
	SQL CONSTRAINT
	SQL PRIMARY KEY
	SQL FOREIGN KEY
	SQL CREATE VIEW
	SQL CREATE INDEX
	SQL ALTER TABLE
	SQL DROP TABLE
	SQL TRUNCATE TABLE
	SQL INSERT INTO
	SQL DELETE FROM
	IT Jobs
	Software Jobs
	Networking Jobs
	Model Question Papers
	BE Computer Science
	MCA
	BCA
	Others

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 CREATE TABLE section, we simply type

DROP TABLE customer

<< Previous | Next >>