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 :: how to import mysql database command line
Sql :: identity syntax in sql
Sql :: find a column by name in a sql server table
Sql :: soql more than today
Sql :: show tablespace oracle
Sql :: how to find total working hour in sql
Sql :: mysql updating multiple column values from array variable
Sql :: php delete database
Sql :: oracle lock user
Sql :: how to get the maximum length of a name in sql
Sql :: psql check tables command
Sql :: sql group by example
Sql :: mysql select row with max value group by
Sql :: mariadb create view
Sql :: mysql show foreign keys column
Sql :: delete from select postgresql
Sql :: date in mysql
Sql :: sql check if table exists
Sql :: sql server python connection
Sql :: mysql select inside sum
Sql :: mysql sort asc numeric
Sql :: what is unique key in sql
Sql :: plpgsql coalesce equivalent for empty string
Sql :: oracle last connection
Sql :: azure sql get all users
Sql :: postgres insert into table
Sql :: oracle for loop on list
Sql :: how to check current root password in mysql
Sql :: convert sql server guid to varbinary
Sql :: how to connect sqlalchemy to mysql and deploy it