Shulou(Shulou.com)05/31 Report--

This article will explain in detail what is the syntax format for deleting views in SQL. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

The sql statement to delete the view is "DROP VIEW" in the format "DROP VIEW [, …]" . the "DROP VIEW" statement can delete multiple views at a time, but you must have DROP permission on each view.

To delete a view is to delete a view that already exists in the MySQL database. When you delete a view, you can only delete the definition of the view, not the data.

You can use the DROP VIEW statement to delete the view.

The syntax format is as follows:

DROP VIEW [,...]

Where: specifies the name of the view to delete. The DROP VIEW statement can delete multiple views at a time, but you must have DROP permission on each view.

Example: delete students_info view

Mysql > DROP VIEW IF EXISTS students_info;Query OK, 0 rows affected (0.00 sec) mysql > SHOW CREATE VIEW students_info;ERROR 1146 (42S02): Table 'test_db.students_info' doesn't exist

You can see that the students_info view no longer exists and was successfully deleted.

This is the end of the article on "what is the grammatical format of deleting views in SQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.