MySQL

295 guides

keyboard_arrow_down

Other math topics

Dagster

Pandas

NumPy

Matplotlib

PySpark

MySQL

chevron_leftGeneral table Cookbook

Showing all the fields of a table Deleting a table Showing all tables Creating a table Cloning a table Finding all tables with a specific column name Removing a temporary table Renaming a table Creating a temporary table Restoring a table from an sql file Backing up a table

check_circle

Mark as learned

thumb_up

thumb_down

chat_bubble_outline

Comment

auto_stories Bi-column layout

settings

Deleting a table in MySQL

schedule Aug 12, 2023

Last updated

local_offer

MySQL

Tags

tocTable of Contents

expand_more

Example

mode_heat

Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!

We can delete a table by running the below command:


        
        
            
                
                
                    DROP TABLE IF EXISTS table_name;

We can remove multiple tables in a single command by separating the tables with commas:


        
        
            
                
                
                    DROP TABLE IF EXISTS table1, table2, table3;

Example

To delete an existing table called students:


        
        
            
                
                
                    DROP TABLE IF EXISTS students;
                
            
            Query OK, 0 rows affected (0.01 sec)

To delete existing tables students and info:


        
        
            
                
                
                    DROP TABLE IF EXISTS students, info;
                
            
            Query OK, 0 rows affected (0.02 sec)

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!