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, 1393🔥, 0💬
Popular Posts:
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...