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, 4719👍, 0💬
Popular Posts:
How To Use "IF" Statements on Multiple Conditions? - Oracle DBA FAQ - Understanding PL/SQL Language ...
What will be printed as the resultof the operation below: int x; int modifyvalue() { return(x+=10); ...
How To Return Top 5 Rows? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you want ...
Can you explain duplex contracts in WCF? In duplex contracts when client initiates an operation the ...
Who Developed HTML? HTML was originally developed by Tim Berners-Lee while at CERN, and popularized ...