Skip to content

W3schools

Subscribe Youtube For Video Tutorials
  • Academics
    • Physics
    • Chemistry
    • Math
    • Biology
    • English
    • Hindi
  • Tutorials
    • Quartz scheduler
    • Log4j
    • JUnit
    • Java Mail
    • Java Generics
    • JAXB
    • Jsoup
    • JSON
    • XML Parser
    • Data structure
  • Java
    • Java
    • Collection framework
    • Java date time api
    • Java regex
    • Design patterns
  • Android
  • Servlet
    • JSP
  • Spring
    • Spring
    • Spring AOP
    • Spring DI
    • Spring MVC
    • Spring spel
    • Spring boot
    • Spring security
  • Hibernate
  • WS
    • Stories
  • Python
  • Web
    • Ajax
    • HTML
    • CSS
    • Javascript
    • jQuery
      • jQuery UI
    • PHP
    • TypeScript
    • ReactJS
    • Backbone.js
    • Bootstrap
      • Bootstrap 4
    • XML
      • XML DOM
      • XPath
      • XQuery
      • XSD
      • XSLT
  • Angular
    • AngularJS
    • Angular 7 Tutorial
    • Angular 8 Tutorial
  • DB
    • SQL
    • SQLite
    • MongoDB
    • MySQL
    • Oracle
    • PL/SQL
    • PostgreSQL
    • PouchDB
    • DBMS
  • C
  • More
    • Q&A
    • Quiz
    • Ant
    • CPP
    • JDBC
    • JPA
    • JSF
    • JAR
    • Maven
    • WAR
    • WordPress

DROP TABLE in MySQL

by

DROP TABLE

To delete all the data of a table along with its structure from the MySQL database, the MySQL DROP TABLE statement is used.

Syntax:

DROP TABLE table_name;

Example:

DROP TABLE items;

Explanation:
All the data of the “items” table along with its structure is removed from the database.

Categories MySQL Tags DROP TABLE in MySQL, DROP TABLE in MySQL Example, DROP TABLE in MySQL Syntax
TRUNCATE TABLE in MySQL
VIEW in MySQL
© 2024 W3schools • Built with GeneratePress