Cannot drop table users because other objects depend on it

Use the cascade option:

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).