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, 1386🔥, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...