AnalyzeCode

Page Index

DBMS Introduction

MySQL Database

MySQL Tables

MySQL Queries

MySQL Clauses

MySQL Conditions

MySQL Keys

MySQL Drop table

MYSQL uses a Drop Table statement to delete the existing table. This statement removes the complete data of a table along with the whole structure or definition permanently from the database. So, you must be very careful while removing the table because we cannot recover the lost data after deleting it.

    DROP TABLE  table_name;  
    OR,  
    DROP TABLE  schema_name.table_name;

Let's move on to MySQL Constraints

Previous

MySQL Drop table

Next :

MySQL Constraints

Share this page on :

© 2022 AnalyzeCode.com All rights reserved.