All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.jooq.AlterTableStep Maven / Gradle / Ivy

Go to download

There is a newer version: 3.19.15
Show newest version
/*
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *  http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * Other licenses:
 * -----------------------------------------------------------------------------
 * Commercial licenses for this work are available. These replace the above
 * Apache-2.0 license and offer limited warranties, support, maintenance, and
 * commercial database integrations.
 *
 * For more information, please visit: http://www.jooq.org/licenses
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 */
package org.jooq;

// ...
// ...
// ...
// ...
// ...
// ...
import static org.jooq.SQLDialect.CUBRID;
// ...
import static org.jooq.SQLDialect.DERBY;
// ...
import static org.jooq.SQLDialect.FIREBIRD;
import static org.jooq.SQLDialect.H2;
// ...
import static org.jooq.SQLDialect.HSQLDB;
import static org.jooq.SQLDialect.IGNITE;
// ...
// ...
import static org.jooq.SQLDialect.MARIADB;
// ...
import static org.jooq.SQLDialect.MYSQL;
// ...
// ...
import static org.jooq.SQLDialect.POSTGRES;
// ...
// ...
// ...
// ...
import static org.jooq.SQLDialect.SQLITE;
// ...
// ...
// ...
// ...
// ...
// ...
import static org.jooq.SQLDialect.YUGABYTEDB;

import java.util.Collection;

import org.jooq.impl.DSL;

import org.jetbrains.annotations.NotNull;


/**
 * The step in the ALTER TABLE statement where the action can be
 * decided.
 * 

 * 
Referencing XYZ*Step types directly from client code

 * 

 * It is usually not recommended to reference any XYZ*Step types
 * directly from client code, or assign them to local variables. When writing
 * dynamic SQL, creating a statement's components dynamically, and passing them
 * to the DSL API statically is usually a better choice. See the manual's
 * section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.
 * 

 * Drawbacks of referencing the XYZ*Step types directly:
 * 
    
 * 
  • They're operating on mutable implementations (as of jOOQ 3.x)
    • 
 * 
  • They're less composable and not easy to get right when dynamic SQL gets
 * complex
    • 
 * 
  • They're less readable
    • 
 * 
  • They might have binary incompatible changes between minor releases
    • 
 * 

 *
 * @author Lukas Eder
 */
public interface AlterTableStep {

    /**
     * Specify a comment for a table using MySQL's syntax.
     *
     * @see DSL#commentOnTable(Table)
     * @see DSLContext#commentOnTable(Table)
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableFinalStep comment(String comment);

    /**
     * Specify a comment for a table using MySQL's syntax.
     *
     * @see DSL#commentOnTable(Table)
     * @see DSLContext#commentOnTable(Table)
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableFinalStep comment(Comment comment);

    /**
     * Add a RENAME TO clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB })
    AlterTableFinalStep renameTo(Table newName);

    /**
     * Add a RENAME TO clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB })
    AlterTableFinalStep renameTo(Name newName);

    /**
     * Add a RENAME TO clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB })
    AlterTableFinalStep renameTo(String newName);

    /**
     * Add a RENAME COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB })
    AlterTableRenameColumnToStep renameColumn(Field oldName);

    /**
     * Add a RENAME COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB })
    AlterTableRenameColumnToStep renameColumn(Name oldName);

    /**
     * Add a RENAME COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB })
    AlterTableRenameColumnToStep renameColumn(String oldName);

    /**
     * Add a RENAME INDEX clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ DERBY, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
    AlterTableRenameIndexToStep renameIndex(Name oldName);

    /**
     * Add a RENAME INDEX clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ DERBY, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
    AlterTableRenameIndexToStep renameIndex(Index oldName);

    /**
     * Add a RENAME INDEX clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ DERBY, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
    AlterTableRenameIndexToStep renameIndex(String oldName);

    /**
     * Add a RENAME CONSTRAINT clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, H2, HSQLDB, POSTGRES, YUGABYTEDB })
    AlterTableRenameConstraintToStep renameConstraint(Constraint oldName);

    /**
     * Add a RENAME CONSTRAINT clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, H2, HSQLDB, POSTGRES, YUGABYTEDB })
    AlterTableRenameConstraintToStep renameConstraint(Name oldName);

    /**
     * Add a RENAME CONSTRAINT clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, H2, HSQLDB, POSTGRES, YUGABYTEDB })
    AlterTableRenameConstraintToStep renameConstraint(String oldName);

    /**
     * Add an ALTER CONSTRAINT clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #alterConstraint(Constraint)}.
     */
    @NotNull @CheckReturnValue
    @Support({ MYSQL })
    AlterTableAlterConstraintStep alter(Constraint constraint);

    /**
     * Add an ALTER COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #alterColumn(Field)}.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
     AlterTableAlterStep alter(Field field);

    /**
     * Add an ALTER COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #alterColumn(Name)}
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableAlterStep alter(Name field);

    /**
     * Add an ALTER COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #alterColumn(String)}
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableAlterStep alter(String field);

    /**
     * Add an ALTER COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
     AlterTableAlterStep alterColumn(Field field);

    /**
     * Add an ALTER COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableAlterStep alterColumn(Name field);

    /**
     * Add an ALTER COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableAlterStep alterColumn(String field);

    /**
     * Add an ALTER CONSTRAINT clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ MYSQL })
    AlterTableAlterConstraintStep alterConstraint(Constraint constraint);

    /**
     * Add an ALTER CONSTRAINT clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ MYSQL })
    AlterTableAlterConstraintStep alterConstraint(Name constraint);

    /**
     * Add an ALTER CONSTRAINT clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ MYSQL })
    AlterTableAlterConstraintStep alterConstraint(String constraint);

    /**
     * Add an ADD COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #addColumn(Field)}.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableAddStep add(Field field);

    /**
     * Add an ADD clause with multiple columns or constraints to
     * the ALTER TABLE statement.
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, IGNITE, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableAddStep add(TableElement... fields);

    /**
     * Add an ADD clause with multiple columns or constraints to
     * the ALTER TABLE statement.
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, IGNITE, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableAddStep add(Collection fields);

    /**
     * Add an ADD COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #addColumn(Field, DataType)}.
     */
    @NotNull @CheckReturnValue
    @Support
     AlterTableAddStep add(Field field, DataType type);

    /**
     * Add an ADD COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #addColumn(Name, DataType)}.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableAddStep add(Name field, DataType type);

    /**
     * Add an ADD COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #addColumn(String, DataType)}.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableAddStep add(String field, DataType type);

    /**
     * Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #addColumnIfNotExists(Field)}.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableAddStep addIfNotExists(Field field);

    /**
     * Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #addColumnIfNotExists(Field, DataType)}.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
     AlterTableAddStep addIfNotExists(Field field, DataType type);

    /**
     * Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #addColumnIfNotExists(Name, DataType)}.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableAddStep addIfNotExists(Name field, DataType type);

    /**
     * Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #addColumnIfNotExists(String, DataType)}.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableAddStep addIfNotExists(String field, DataType type);

    /**
     * Add an ADD COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableAddStep addColumn(Field field);

    /**
     * Add an ADD COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support
     AlterTableAddStep addColumn(Field field, DataType type);

    /**
     * Add an ADD COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableAddStep addColumn(Name field, DataType type);

    /**
     * Add an ADD COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableAddStep addColumn(String field, DataType type);

    /**
     * Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableAddStep addColumnIfNotExists(Field field);

    /**
     * Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
     AlterTableAddStep addColumnIfNotExists(Field field, DataType type);

    /**
     * Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableAddStep addColumnIfNotExists(Name field, DataType type);

    /**
     * Add an ADD COLUMN IF NOT EXISTS clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableAddStep addColumnIfNotExists(String field, DataType type);

    /**
     * Add an ADD CONSTRAINT clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableUsingIndexStep add(Constraint constraint);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #dropColumn(Field)}.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableDropStep drop(Field field);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #dropColumn(Name)}.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableDropStep drop(Name field);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #dropColumn(String)}.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableDropStep drop(String field);

    /**
     * Add an DROP COLUMN IF EXISTS clause to the
     * ALTER TABLE statement.
     * 

     * This is an alias for {@link #dropColumnIfExists(Field)}.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropIfExists(Field field);

    /**
     * Add an DROP COLUMN IF EXISTS clause to the
     * ALTER TABLE statement.
     * 

     * This is an alias for {@link #dropColumnIfExists(Name)}.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropIfExists(Name field);

    /**
     * Add an DROP COLUMN IF EXISTS clause to the
     * ALTER TABLE statement.
     * 

     * This is an alias for {@link #dropColumnIfExists(String)}.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropIfExists(String field);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableDropStep dropColumn(Field field);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableDropStep dropColumn(Name field);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support
    AlterTableDropStep dropColumn(String field);

    /**
     * Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropColumnIfExists(Field field);

    /**
     * Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropColumnIfExists(Name field);

    /**
     * Add an DROP COLUMN IF EXISTS clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, IGNITE, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropColumnIfExists(String field);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #dropColumns(Collection)}.
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, IGNITE, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep drop(Field... fields);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #dropColumns(Collection)}.
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, IGNITE, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep drop(Name... fields);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #dropColumns(Collection)}.
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, IGNITE, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep drop(String... fields);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, IGNITE, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropColumns(Field... fields);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, IGNITE, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropColumns(Name... fields);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, IGNITE, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropColumns(String... fields);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     * 

     * This is an alias for {@link #dropColumns(Collection)}.
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, IGNITE, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep drop(Collection> fields);

    /**
     * Add an DROP COLUMN clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ FIREBIRD, H2, IGNITE, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropColumns(Collection> fields);

    /**
     * Add a DROP CONSTRAINT clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableDropStep drop(Constraint constraint);

    /**
     * Add a DROP CONSTRAINT clause to the ALTER TABLE
     * statement.
     *
     * @see DSL#constraint(String)
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropConstraint(Constraint constraint);

    /**
     * Add a DROP CONSTRAINT clause to the ALTER TABLE
     * statement.
     *
     * @see DSL#constraint(String)
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropConstraint(Name constraint);

    /**
     * Add a DROP CONSTRAINT clause to the ALTER TABLE
     * statement.
     *
     * @see DSL#constraint(String)
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropConstraint(String constraint);

    /**
     * Add a DROP CONSTRAINT IF EXISTS clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ H2, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropIfExists(Constraint constraint);

    /**
     * Add a DROP CONSTRAINT IF EXISTS clause to the ALTER TABLE
     * statement.
     *
     * @see DSL#constraint(String)
     */
    @NotNull @CheckReturnValue
    @Support({ H2, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropConstraintIfExists(Constraint constraint);

    /**
     * Add a DROP CONSTRAINT IF EXISTS clause to the ALTER TABLE
     * statement.
     *
     * @see DSL#constraint(String)
     */
    @NotNull @CheckReturnValue
    @Support({ H2, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropConstraintIfExists(Name constraint);

    /**
     * Add a DROP CONSTRAINT IF EXISTS clause to the ALTER TABLE
     * statement.
     *
     * @see DSL#constraint(String)
     */
    @NotNull @CheckReturnValue
    @Support({ H2, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropConstraintIfExists(String constraint);

    /**
     * Add a DROP PRIMARY KEY clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ DERBY, H2, HSQLDB, MARIADB, MYSQL })
    AlterTableDropStep dropPrimaryKey();

    /**
     * Add a DROP PRIMARY KEY clause to the
     * ALTER TABLE statement.
     * 

     * Dialect families derived from MySQL do not know named constraints, in
     * case of which this clause simply generates DROP PRIMARY KEY
     * as in {@link #dropPrimaryKey()}. In other dialect families, this produces
     * a DROP CONSTRAINT [name] clause, as in
     * {@link #dropConstraint(Constraint)}.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
    AlterTableDropStep dropPrimaryKey(Constraint constraint);

    /**
     * Add a DROP PRIMARY KEY clause to the ALTER TABLE
     * statement.
     * 

     * Dialect families derived from MySQL do not know named constraints, in
     * case of which this clause simply generates DROP PRIMARY KEY
     * as in {@link #dropPrimaryKey()}. In other dialect families, this produces
     * a DROP CONSTRAINT [name] clause, as in
     * {@link #dropConstraint(Name)}.
     *
     * @see DSL#constraint(Name)
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
    AlterTableDropStep dropPrimaryKey(Name constraint);

    /**
     * Add a DROP PRIMARY KEY clause to the ALTER TABLE
     * statement.
     * 

     * Dialect families derived from MySQL do not know named constraints, in
     * case of which this clause simply generates DROP PRIMARY KEY
     * as in {@link #dropPrimaryKey()}. In other dialect families, this produces
     * a DROP CONSTRAINT [name] clause, as in
     * {@link #dropConstraint(String)}.
     *
     * @see DSL#constraint(String)
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
    AlterTableDropStep dropPrimaryKey(String constraint);

    /**
     * Add a DROP UNIQUE clause to the ALTER TABLE
     * statement.
     * 

     * Some dialects (e.g. {@link SQLDialect#COCKROACHDB}) may not be able to
     * drop constraints by name. If users specify the constraint type
     * and the name, however, then the syntax can be emulated, e.g.
     * using DROP INDEX … CASCADE.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropUnique(Constraint constraint);

    /**
     * Add a DROP UNIQUE clause to the ALTER TABLE
     * statement.
     * 

     * Some dialects (e.g. {@link SQLDialect#COCKROACHDB}) may not be able to
     * drop constraints by name. If users specify the constraint type
     * and the name, however, then the syntax can be emulated, e.g.
     * using DROP INDEX … CASCADE.
     *
     * @see DSL#constraint(Name)
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropUnique(Name constraint);

    /**
     * Add a DROP UNIQUE clause to the ALTER TABLE
     * statement.
     * 

     * Some dialects (e.g. {@link SQLDialect#COCKROACHDB}) may not be able to
     * drop constraints by name. If users specify the constraint type
     * and the name, however, then the syntax can be emulated, e.g.
     * using DROP INDEX … CASCADE.
     *
     * @see DSL#constraint(String)
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropUnique(String constraint);

    /**
     * Add a DROP FOREIGN KEY clause to the ALTER TABLE
     * statement.
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropForeignKey(Constraint constraint);

    /**
     * Add a DROP FOREIGN KEY clause to the ALTER TABLE
     * statement.
     *
     * @see DSL#constraint(Name)
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropForeignKey(Name constraint);

    /**
     * Add a DROP FOREIGN KEY clause to the ALTER TABLE
     * statement.
     *
     * @see DSL#constraint(String)
     */
    @NotNull @CheckReturnValue
    @Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, YUGABYTEDB })
    AlterTableDropStep dropForeignKey(String constraint);
}
    

    

    

            

    

            



    
    






    
© 2015 - 2024 Weber Informatics LLC | Privacy Policy