SQL DROP VIEW statement removes view definition from the system catalog and the dependent objects of that view will become invalid.Here are some syntaxes of DROP VIEW statement in some common RDBMSs:
DROP VIEW in MS SQL server
you can drop multiple views usinh DROP VIEW statement, each view's name is seperated by a comma.