Easy Tutorial
Postgresql Like Postgresql Syntax Postgresql With Postgresql Null Postgresql Lock Postgresql View Postgresql Privileges Postgresql Limit Postgresql And Or Clauses Postgresql Autoincrement Postgresql Expressions Postgresql Data Type Postgresql Constraints Postgresql Where Clause Postgresql Drop Database Postgresql Select Database Windows Install Postgresql Postgresql Select Linux Install Postgresql Postgresql Join Postgresql Index Postgresql Tutorial Postgresql Schema Postgresql Trigger Postgresql Delete Postgresql Update Postgresql Alias Postgresql Union Postgresql Alter Table Postgresql Functions Postgresql Truncate Table Postgresql Group By Postgresql Sub Queries Postgresql Having Postgresql Insert Into Postgresql Create Table Postgresql Order By Postgresql Datetime Postgresql Create Database Postgresql Drop Table Postgresql Operators Postgresql Transaction Postgresql Distinct Mac Install Postgresql
❮ Postgresql Create Database Postgresql Operators ❯

PostgreSQL Deleting Tables

PostgreSQL uses the DROP TABLE statement to delete tables, which includes the table data, rules, triggers, etc. Therefore, deleting a table should be done with caution, as all information will be lost once the table is deleted.

Syntax

The DROP TABLE syntax is as follows:

DROP TABLE table_name;

Example

In the previous chapter, we created two tables: COMPANY and DEPARTMENT. We can first use the \d command to check if the tables were created successfully:

tutorialprodb=# \d
           List of relations
 Schema |    Name    | Type  |  Owner   
--------+------------+-------+----------
 public | company    | table | postgres
 public | department | table | postgres
(2 rows)

From the above results, we can see that the tables were created successfully. Next, we will delete these two tables:

tutorialprodb=# drop table department, company;
DROP TABLE

Using the \d command again will show that the tables are no longer present:

testdb=# \d
Did not find any relations.
❮ Postgresql Create Database Postgresql Operators ❯