PostgreSQL - DROP Table

Advertisements


The PostgreSQL DROP TABLE statement is used to remove a table definition and all associated data, indexes, rules, triggers, and constraints for that table.

You have to be careful while using this command because once a table is deleted then all the information available in the table would also be lost forever.

Syntax

Basic syntax of DROP TABLE statement is as follows.

DROP TABLE table_name;

Example

We had created the tables DEPARTMENT and COMPANY in the previous chapter. First verify these tables (use \d to list the tables):

testdb-# \d

This would produce the following result:

           List of relations
 Schema |    Name    | Type  |  Owner
--------+------------+-------+----------
 public | company    | table | postgres
 public | department | table | postgres
(2 rows)

This means DEPARTMENT and COMPANY tables are present. So let us drop them as follows:

testdb=# drop table department, company;

This would produce the following result:

DROP TABLE
testdb=# \d
 relations found.
testdb=# 

The message returned DROP TABLE indicates that drop command had been executed successfully.



Advertisements
Advertisements