The PostgreSQL Drop Table can be dropped by using the pgAdmin3. And these pgAdmin is a graphical interface, that provides the user to easily understand and to access the database features conveniently. PostgreSQL allows a clients for executing multiple number of action based on the given code, that contains exchanging multiples externally beyond the code source. These are additionally contain the necessity which are related to the copyright that display in each and every software that are duplicated. The PostgreSQL DROP TABLE statement is used to drop a table definition and all associated data like triggers, indexes, rules and constraints for that table.
PostgreSQL Drop Table Database
Description
By viewing the below steps of PostgreSQL Drop Table, the concept of dropping a table from the postgreSQL database can be easily understand.
Step - 1
In postgreSQL, a database by name SQLDB has been created as shown below.
Step - 2
In SQLDB database a table by name student has been created as shown below.
Step - 3
The student table contain the column name like student_id,student_Name and course as shown below.
Step - 4
Right click on table name student and select Delete/Drop option as shown below.
Step - 5
Click on Yes button as shown below.
Step - 6
The table student has been successfully dropped from the SQLDB database as shown below.
Summary
Key Points
PostgreSQL Dropping a table - Here the entire table will be dropped from the database.
PostgreSQL Dropping a table - Can also be performed in command prompt.