[, The SQL statement to delete a view is "DROP VIEW", and the specific format is "DROP VIEW ea5dd2fbdee480281a8391047fa1af45 [, 11c1ebc9145b5e9169848415c92df795 ...]". The "DROP VIEW" statement can delete multiple views at one time, but you must have DROP permission on each view. The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer. Deleting a view refers to deleting an existing view in the MySQL database. When you delete a view, only the definition of the view is deleted, but the data is not deleted. You can use the DROP VIEW statement to delete a view. The syntax format is as follows: Among them: Example: Delete the students_info view You can see that the students_info view no longer exists and it was deleted successfully. For more knowledge about computer programming, please visit: Introduction to Programming! ! The above is the detailed content of What is the sql statement to delete a view?. For more information, please follow other related articles on the PHP Chinese website!What is the sql statement to delete a view?
DROP VIEW <视图名1> [ , <视图名2> …]
f96a157a4ed7a8435db1751107a46e3c
Specify the name of the view to be deleted. The DROP VIEW statement can drop multiple views at once, but you must have DROP permission on each 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