Postgresql delete table if exists how to#

Read How to create a view in PostgreSQL PostgreSQL DROP TABLE wildcard Then, the DROP TABLE statement with CASCADE keyword is used to remove the table table_name forcefully with its associated objects.Įxample: - When the owner of the sequence is the table that you are dropping.OWNED BY clause is used to change the owner of the sequence to the table table_name‘s column column_name.ALTER SEQUENCE is the statement used to modify the sequence sequence_object_name.OWNED BY table_lumn_name ] - if the owner is not the table then do this The syntax is as follow: [ALTER SEQUENCE sequence_object_name If you have created a sequence and used it for a column’s default of a table in PostgreSQL, then you can remove the table with the sequence associated with it, using the DROP TABLE statement with the keyword CASCADE.īut the sequence has to be owned by the table to be dropped, if not then, you have to change the owner of the sequence to, the column of the table. Read PostgreSQL DROP COLUMN PostgreSQL DROP TABLE CASCADE sequence The syntax is as follow: DROP TABLE table_nameĮxample: - Let's create some tables to perform the tasksįOREIGN KEY(dep_id) REFERENCES department) If you don’t want to force, dropping off the table to which other objects depend, you can skip the CASCADE keyword or you can specify the keyword RESTRICT which is by default for the DROP TABLE statement, that refuse to drop the table if any objects depend on it. In the above syntax, you can also specify more than one table to be removed from the database, and the CASCADE keyword will do the same for all the tables. The syntax is as follows: DROP TABLE table_name When the table that you want to remove is referenced by a FOREIGN KEY constraint of some other table or a VIEW, CASCADE must be specified, as CASCADE removes any dependent VIEW entirely and removes the FOREIGN KEY constraint from the referencing table (another table). Read PostgreSQL INSERT Multiple Rows PostgreSQL DROP TABLE CASCADE You can see in the above example some other objects that are SEQUENCE automatically removed, as the tables we have removed are the owner of these objects. NOTE – You have to be the owner of the tables that you are removing or a superuser to remove those tables from the database, else you can’t.Įxample: - I have some already existing tables and objects.IF EXISTS, CASCADE and RESTRICT are the optional keywords.table_name is the name of the table that you want to remove from the database.It destroys the table with the indexes, rules, triggers, and constraints related to that table. You can remove table(s) from the database in PostgreSQL by using the statement DROP TABLE. PostgreSQL DROP TABLE CASCADE IF EXISTS.

Postgresql delete table if exists