SQL Extensions   «Prev 

What happens when you drop a table in Oracle?

1) Here is a diagram showing the CUSTOMER table and all the related objects in the database. The following elements exist: 1) index, 2) privileges, 3) a view, 4) a foreign key in a another table, 5) a view , and a 6) synonym. What happens to all these objects if we drop the CUSTOMER table?

2) As illustrated here, some of the objects are dropped along with the table while other objects are left in the database. These objects that remain will cause errors if they are used at any time after this point. They must either be either dropped or revised.