PostgreSQL DROP TABLE

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.
Please follow and like us:
Content Protection by DMCA.com