DROP TABLE Query is used to Delete or Drop a table from MySQL Database.
Syntax:
This will delete users table. But this will throw error if users table is not there.
DROP TABLE users
This will delete users table only if it exist.
DROP TABLE IF EXISTS users
Modules:
- mysql: To handle MySQL connection and Queries
npm install mysql
SQL gfg_db
Database Preview (showing tables):
Example 1: Delete users Table
Javascript
const mysql = require( "mysql" );
let db_con = mysql.createConnection({
host: "localhost" ,
user: "root" ,
password: '' ,
database: 'gfg_db'
});
db_con.connect((err) => {
if (err) {
console.log( "Database Connection Failed !!!" , err);
return ;
}
console.log( "We are connected to gfg_db database" );
let query = 'DROP TABLE users' ;
db_con.query(query, (err, rows) => {
if (err) throw err;
console.log( 'Deleted users Table' );
});
});
|
Output:
Example 2: Delete users Table only if it Exists
Javascript
const mysql = require( "mysql" );
let db_con = mysql.createConnection({
host: "localhost" ,
user: "root" ,
password: '' ,
database: 'gfg_db'
});
db_con.connect((err) => {
if (err) {
console.log( "Database Connection Failed !!!" , err);
return ;
}
console.log( "We are connected to gfg_db database" );
let query = 'DROP TABLE IF EXISTS users' ;
db_con.query(query, (err, rows) => {
if (err) throw err;
console.log( 'Deleted users Table' );
});
});
|
Output:
Last Updated :
07 Oct, 2021
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...