Removes a view from the database. Multiple views can be dropped with a single DROP VIEW command. This command is not reversible.
Clause that indicates that if the specified view doesn't exist, the command should make no changes and return a message that the view doesn't exist, rather than terminating with an error.
This clause is useful when scripting, so the script doesn't fail if DROP VIEW runs against a nonexistent view.
Name of the view to be removed.
Clause that indicates to automatically drop objects that depend on the view, such as other views.
To create a view that is not dependent on other database objects, such as views and tables, include the WITH NO SCHEMA BINDING clause in the view definition. For more information, see CREATE VIEW.
Clause that indicates not to drop the view if any objects depend on it. This action is the default.
At this point, two views have been created: eventview and myeventview.
The myeventview view is a child view witheventview as its parent.
Both eventview and myeventview have now been dropped successfully.