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, 1156👍, 0💬
Popular Posts:
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...