cannot drop table because other objects depend on it

Thebetta answered on July 10, 2023 Popularity 3/10 Helpfulness 5/10

answer cannot drop table because other objects depend on it

Comment

DROP TABLE if exists users cascade;

this will drop any foreign key that is referencing the users table or any view using it.

It will not drop other tables (or delete rows from them).

Popularity 3/10 Helpfulness 5/10 Language sql

Tags: drop-table sql

Link to this answer
Share Copy Link

Contributed on Jul 10 2023

Thebetta

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.