Python PostgreSQL – Drop Table
Last Updated :
23 Aug, 2021
In this article, we are going to see how to drop tables in PostgreSQL using pyscopg2 module Python. In PostgreSQL DROP TABLE is used to remove the existing table from the database. It removes table definition and all associated data, indexes, rules, triggers, and constraints for that table. If the particular table doesn’t exist then it shows an error.
Syntax: DROP TABLE table_name;
Table Used:
Here, we are using the accounts table for demonstration.
Now let’s drops this table, for we will use will psycopg2 module to connect the PostgreSQL and execute the SQL query in cursor.execute(query) object.
Syntax: cursor.execute(sql_query);
Example 1: Drop table using psycopg2
Here we are going to drop the table using the DELETE clause.
Syntax: DROP TABLE table_name;
Code:
Python3
import psycopg2
conn=psycopg2.connect(
database="test",
user="postgres",
password="password",
host="localhost",
port="5432"
)
cursor = conn.cursor()
sql =
cursor.execute(sql)
print("Table dropped !")
conn.commit()
conn.close()
|
Output:
Table dropped !
Example 2: Drop table before checking it is exist or not
If you try to delete the same table again, since you have already deleted it, you will get an error saying “table does not exist”, so we can resolve using the IF EXIST clause.
Syntax: DROP TABLE table_name IF EXITS table_name;
Code:
Python3
import psycopg2
conn=psycopg2.connect(
database="geeks",
user="postgres",
password="root",
host="localhost",
port="5432"
)
cursor = conn.cursor()
sql =
cursor.execute(sql)
print("Table dropped !")
conn.commit()
conn.close()
|
Output:
Table dropped !
After execution of the scripts, let check the table in PostgreSQL:
Like Article
Suggest improvement
Share your thoughts in the comments
Please Login to comment...