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 :: postgres group by 10 minute intervals
Sql :: postgres set default schema
Sql :: shrink database file in sql server
Sql :: insert value in identity
Sql :: flask sqlalchemy default value
Sql :: mysql backup query
Sql :: postgresql change default value
Sql :: mysql columns values as comma separated string
Sql :: mysql change collation one column
Sql :: add column with foreign key constraint sql server
Sql :: join update query in sql
Sql :: get name of day in sql
Sql :: change column name in sql
Sql :: SQLSTATE[IMSSP]: The active result for the query contains no fields.
Sql :: get duplicate records in sql
Sql :: sql server select value large text
Sql :: pl/sql loop example
Sql :: mysql grant access to one database
Sql :: When mysql server would not work in xampp
Sql :: pl/sql cursor
Sql :: how to delete user in mysql
Sql :: enable constraint in sql
Sql :: run sql file in terminal
Sql :: check if database exists sql
Sql :: not exists mysql
Sql :: sqlite indexes
Sql :: mysql query dates between two dates
Sql :: mysql select into new table
Sql :: oracle tablespace tables list
Sql :: varchar vs nvarchar sql