Method addConstraint

lib/dialects/abstract/query-interface.js:733–746

* Add a constraint to a table * * Available constraints: * - UNIQUE * - DEFAULT (MSSQL only) * - CHECK (MySQL - Ignored by the database engine ) * - FOREIGN KEY * - PRIMARY KEY * * @example <caption>UNIQUE</caption> * queryInterface.addConstraint('Users', { * field

(tableName, options)

   * @returns {Promise}
   */
  async addConstraint(tableName, options) {
    if (!options.fields) {
      throw new Error(class="st">'Fields must be specified through options.fields');
    }

    if (!options.type) {
      throw new Error(class="st">'Constraint type must be specified through options.type');
    }

    options = Utils.cloneDeep(options);

    const sql = this.queryGenerator.addConstraintQuery(tableName, options);
    return await this.sequelize.query(sql, options);
  }

  async showConstraint(tableName, constraintName, options) {
    const sql = this.queryGenerator.showConstraintsQuery(tableName, constraintName);