Sql

/* To Drop Unique Key Constraint*/
ALTER TABLE Table_Name
DROP CONSTRAINT Constraint_Name

example: alter table DropIndex drop index BookId ;

SHOW CREATE TABLE [tableName]
-- Find the constraintID after CONSTRAINT 'constraintID'
ALTER TABLE [tableName] DROP FOREIGN KEY constraintID

PREVIOUS	NEXT

Code Example
Sql :: mysql email validation
Sql :: create view in sql
Sql :: mysql between
Sql :: check if sql is installed
Sql :: postgresql check privileges on schema
Sql :: alter table add multiple columns postgresql
Sql :: sql current date
Sql :: select milliseconds mysql
Sql :: mysql copy table to another table
Sql :: sql convert varchar to date
Sql :: jwt laravel
Sql :: mysql get latest duplicate rows
Sql :: sql delete all values in a column
Sql :: print hello world in plsql
Sql :: drop column from local database postgres pgadmin
Sql :: IS NOT NULL statement
Sql :: mysql add column to table
Sql :: how to connect sql database in python
Sql :: return result of function in postgresql
Sql :: mysql backup database
Sql :: import sql dump into postgresql database
Sql :: join multiple tables sql
Sql :: postgress connection refused
Sql :: sql select rows with different values in one column
Sql :: SQL query to verify the size of the table
Sql :: postgres top 10
Sql :: mysql select row with min date
Sql :: how to display value of variable in mysql
Sql :: SQL SERVER ORDER BY DATE NULL LAST
Sql :: sql joins