How to removeConstraint defaultValue in Sequelize

Question

I'm trying to write a migration in Sequelize and want to remove the defaultValue constraint. What is the proper syntax? I've tried both of the following:

return queryInterface.removeConstraint('Table', 'table_columnName_default')
return queryInterface.removeConstraint('Table', 'columnName_default')

score 7 · Accepted Answer · edited Sep 03 '18 at 17:36

7

Can you please try to use

return queryInterface.changeColumn('Table', 'attributeName', {
    defaultValue: null,
    allowNull: true,
});

http://docs.sequelizejs.com/class/lib/query-interface.js~QueryInterface.html#instance-method-changeColumn

edited Sep 03 '18 at 17:36

Uladzislau Vavilau

891
8
15

answered Aug 30 '18 at 07:59

Rahul Sharma

1,393
10
19

4

I edited the answer above to add type -- this is necessary else the migration fails. – clewiston Sep 05 '18 at 15:02

score 0 · Answer 2 · answered Apr 21 '20 at 14:41

0

You can also use a raw query:

return queryInterface.sequelize.query(`ALTER TABLE table ALTER COLUMN column DROP DEFAULT;`)

answered Apr 21 '20 at 14:41

pwerth

210
1
6
14

score 0 · Answer 3 · answered Jun 15 '23 at 08:02

you should know the data type. for e.g. STRING:

const { DataTypes } = require('sequelize');

return queryInterface.changeColumn('Table', 'attributeName', {
    defaultValue: null,
    type: DataTypes.STRING
});

you can also use queryInterface from the model definition (or pass the model/query interface) to make it generic for any column with default value:

function dropDefaults(queryInterface, model) {
  const defaultValues = Object.keys(model._defaultValues);
  for (const column of defaultValues) {
    model.queryInterface.changeColumn(model.tableName, column, {
      defaultValue: null,
      type: model.fieldRawAttributesMap[column].type,
    });
  }
}

How to removeConstraint defaultValue in Sequelize

3 Answers3