Consider the following statement:
DROP VIEW CityPop, CountryCodes, StatePop
All three views exist at the time the statement is executed.
Which of the following results should be expected when executing the statement?
A.
An error message will be issued for trying to drop more than one view in a single statement.
B.
A warning message is issued for trying to drop more than one view in a single statement.
C.
All the views will be successfully destroyed.
D.
The first view will be destroyed if it is not dependent on the following two views.
Explanation:
— DROP VIEW IF EXISTS v1, v2; ok to crop multiple views together p253