Saved Bookmarks
| 1. |
What happens if you try to drop a table on which a view exists? |
|
Answer» If we try to drop a table on which a view exist, then the table is dropped but DBMS invalidates these dependent views but does not drop them. We cannot use these views unless we recreate the table or drop and recreate the objects so that they no longer depend on the table. |
|