Sql

DROP CONSTRAINT ConstraintName;

-- removing CHECK constraint named amountCK
ALTER TABLE Orders
DROP CONSTRAINT amountCK;

/*To Drop Check Constraint*/
ALTER TABLE (Table_Name)
DROP CONSTRAINT (Constraint_Name)

ALTER TABLE (TABLE_NAME)
DROP CONSTRAINT (TABLENAME)_(COLUMNNAME)_CK;

ALTER TABLE TABLENAME
DROP CONSTRAINT TBNAME_COLNAME_CK;

PREVIOUS	NEXT

Code Example
Sql :: WHERE not regex in SQL
Sql :: mysql ilike
Sql :: Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘a’.
Sql :: create temporary table sql
Sql :: q operator in plsql
Sql :: mysql create table from select statement
Sql :: update foreign key value in mysql
Sql :: sql not in
Sql :: intellij mysql set timezone
Sql :: Add image in MySQL database
Sql :: mysql not defined
Sql :: sql having clause
Sql :: pivot
Sql :: snowflake select from stage
Sql :: sql select date add day
Sql :: mysql random
Sql :: postgresql if else endif
Sql :: how to pass dynamic column name in sql query
Sql :: how to print sql query
Sql :: oracle default date format
Sql :: postgres left join
Sql :: sql select where
Sql :: mysql if statement
Sql :: oracle sql average
Sql :: Write an SQL query to fetch worker names with salaries = 50000 and <= 100000.
Sql :: nth highest salary in sql
Sql :: mysql find db contarint
Sql :: oracle privileges users
Sql :: json_remove mysql
Sql :: sql pivot without aggregate