Before drop the table If any constraints exsits drop the constraints by using the below query
else If you want to drop all the constraints and table use below query
drop table <table_name> cascade constraints
eg: drop table sample cascade constraints
It will drop all the constraints and table as well.
else If you want to drop all the constraints and table use below query
drop table <table_name> cascade constraints
eg: drop table sample cascade constraints
It will drop all the constraints and table as well.
No comments:
Post a Comment