What is the sql statement to delete a view?

The SQL statement to delete a view is "DROP VIEW", and the specific format is "DROP VIEW [, ...]". 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:

DROP VIEW <视图名1> [ , <视图名2> …]

Among them: <View name>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.

Example: Delete the 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 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!