System Status
Buy Now
  • Email & Apps
  • Office 365
Login
  • MyRackspace Portal
  • Cloud Control Panel
  • Rackspace Webmail Login
  • Cloud Office Control Panel
  • Support Home
  • How-To
  • Developer Documentation
  •  Blogs 
    • Expert Insights Tech Blog
    • Rackspace Blog
    • Solve: Thought Leadership

Support Network

End-to-End Multicloud Solutions.   Solving Together.â„¢   Learn more at Rackspace.com

How–To Home

Cloud Servers

  • Introduction
  • FAQ
  • All Articles

Drop tables in MySQL

Last updated on:  2020-11-04

Authored by:  James Andrade


You can use the drop table command to remove a table definition and all data, indexes, triggers, constraints, and permission specifications for that table.

IMPORTANT: You should be very careful with this command because after you delete a table, you can’t retrieve any of that information.

You can drop tables within MySQL® and MariaDB® by following these steps:

  1. Login to MySQL or MariaDB:

     root@localhost# mysql -u root -p
     Enter password:*******
    
  2. Change to the database and drop the table:

     mysql> use TESTINGDB;
     Database changed
     mysql> DROP TABLE testing_tbl;
     Query OK, 0 rows affected (0.8 sec)
     mysql>
    

Share this information:

©2020 Rackspace US, Inc.

Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License

See license specifics and DISCLAIMER

About Rackspace
  • About
  • Customer Stories
  • Events
  • Programs
Blogs
  • The Rackspace Blog
  • Expert Insights Tech Blog
  • Solve: Thought Leadership
  • News
  • Contact Information
  • Legal
  • Careers
Site Information
  • Style Guide for Technical Content
  • Trademarks
  • Privacy Statement
  • Website Terms
Support Network
  • Support Network Home
  • Rackspace How-To
  • API Documentation
  • Developer Center
  • ©2020 Rackspace US, Inc.