How I can drop a specific table using sequelize?

Question

I need to drop a specific table from my database using sequelize.

I tried many times but It deletes all tables.

I want to delete only what I defined as CategoryName.

I try this but not working with me

const Sequelize = require('sequelize');
const sequelize = require('../util/database');
const Category = require('../models/category');

exports.postDeleteCategory = (req,res,next) => {
    const categoryId = req.body.categoryId;
    const categoryName = req.body.categoryName+'s';
    Category.destroy({
        where: {
            id: categoryId
        },
        force: true
        }).then(() => {
            console.log('Destroyed Category');
            sequelize.drop(categoryName+'s');
            res.redirect('/categories');
        })
        .catch(err => {
            console.log(err);
        });
}

It is dropped all tables not what I want.

Edward · Accepted Answer · 2023-02-08 15:44:04Z

3

This line here drops all the tables.

sequelize.drop(categoryName+'s');

To drop your table just do

await Category.drop()

answered Feb 8, 2023 at 15:44

Edward

3923 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

othman ali Over a year ago

I don’t want to drop Category table I want to drop another table by passing name of the table

Edward Over a year ago

@othmanali Then do this: sequelize.getQueryInterface().dropTable('tableName')

Collectives™ on Stack Overflow

How I can drop a specific table using sequelize?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related