DROP TABLE
To drop or eliminate a particular PostgreSQL table, one can use the UI or can delete or remove the PostgreSQL table using the DROP TABLE command.
Syntax:
DROP TABLE name;
Parameters:
name: It is used to specify the name of the TABLE to be dropped.
Example:
DROP TABLE employment; |
Explanation:
The ‘employment’ TABLE will be removed.
DROP TABLE using UI:
To drop a TABLE using UI, select the TABLE to delete and right-click on that.
Example:
- To delete the ‘employment’ TABLE, select the TABLE and right-click on that.
- Click on “Drop” from the dropdown menu.
- Click on “YES” from the generated pop-up box.