Collections:
Drop an Existing Table in MySQL
How To Drop an Existing Table in MySQL?
✍: FYIcenter.com
If you want to delete an existing table and its data rows, you can use the "DROP TABLE" statement as shown in the tutorial script below:
mysql> SELECT * FROM tipBackup; +----+-------------+-------------------------+-------------+ | id | subject | description | create_date | +----+-------------+-------------------------+-------------+ | 1 | Learn MySQL | Visit dev.fyicenter.com | 2006-07-01 | +----+-------------+-------------------------+-------------+ 1 row in set (0.40 sec) mysql> DROP TABLE tipBackup; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM tipBackup; ERROR 1146 (42S02): Table 'fyi.tipbackup' doesn't exist
Be careful, when you use the "DROP TABLE" statement. All data rows are gone too.
⇒ Create an Index for a Given Table in MySQL
⇐ Rename an Existing Table in MySQL
2018-02-14, 1475🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...