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, 1186👍, 0💬
Popular Posts:
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are...
How To See Which Storage Engines Are Supported in Your MySQL Server in MySQL? If you want to know ex...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...