Collections:
Drop an Existing View in MySQL
How To Drop an Existing View in MySQL?
✍: FYIcenter.com
If you have an existing view, and you don't want it anymore, you can delete it by using the "DROP VIEW viewName" statement as shown in the following script:
mysql> DROP VIEW faqComment; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM faqComment; ERROR 1146 (42S02): Table 'fyi.faqcomment' doesn't exist
⇒ INSERT, UPDATE and DELETE Statements in MySQL
2018-01-24, 1854🔥, 0💬
Popular Posts:
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...