Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Drop an Existing View
How To Drop an Existing View? - MySQL FAQs - Understanding SQL CREATE, ALTER and DROP Statements
✍: 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
2007-05-11, 4653👍, 0💬
Popular Posts:
What are the core functionalities in XML .NET framework? Can you explain in detail those functionali...
Can two catch blocks be executed? No, once the proper catch section is executed the control goes fin...
What are secure and non-secure websites? A secure Website uses the Secure Socket Layer (SSL) protoco...
How can we implement singleton pattern in .NET? Singleton pattern mainly focuses on having one and o...
How Do You Uninstall JUnit Uninstalling JUnit is easy. Just remember these: Delete the directory tha...