CodesJava

Easy learning with example program codes

DROP TABLE in PostgreSQL

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:
error









Copyright © 2019 CodesJava DMCA.com Protection Status