How To Drop An Existing View In MySQL

  • 15 Dec, 2011

    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 'ggl.faqcomment' doesn't exist

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 All rights reserved.