Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

drop table sales; ERROR: cannot drop table sales because other objects depend on it DETAIL: constraint car_sales_id_fkey on table car depends on table sales HINT: Use DROP ... CASCADE to drop the dependent objects too.

Solution :
Becouse foreign key is there in sales table so if you want to delete that table you need to specify Cascade option

postgres=# drop table sales;
ERROR:  cannot drop table sales because other objects depend on it
DETAIL:  constraint car_sales_id_fkey on table car depends on table sales
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
postgres=# drop table sales cascade;
NOTICE:  drop cascades to constraint car_sales_id_fkey on table car
DROP TABLE
Do you want to learn  More About foreign Key  Click The Below Link

Comments

Popular posts from this blog

PostgreSQL application_name (string)

VMWARE WORKSTATION 3,4,5,6,7,8,9,10,11,12,14,15...etc LICENSE KEYS COLLECTION

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

Postgres Streaming Replication Configuration

Postgres Database Patch