Sql

select distinct CONSTRAINT_NAME
from information_schema.TABLE_CONSTRAINTS
where table_name = 'TableName' and constraint_type = 'UNIQUE';

ALTER TABLE users
ADD UNIQUE (username, delete_date, ...);

PREVIOUS	NEXT

Code Example
Sql :: nested query sql
Sql :: how to find max and min salary in sql
Sql :: get stored procedure text sql server
Sql :: import database mysql command line
Sql :: inner join mysql
Sql :: alter boolean column postgresql
Sql :: mysql size of database
Sql :: nested select sql
Sql :: mysql dump
Sql :: dump multiple tables mysql
Sql :: sql if function
Sql :: mysql order by on condition
Sql :: sql describe
Sql :: sql where is not number
Sql :: insert or update sql query
Sql :: sql rename column in select
Sql :: mysql date time string format for marshmellow field schema
Sql :: sql get actual fiscal year
Sql :: sqlite create record
Sql :: postgresql isnull with max
Sql :: cara menampilkan user di mysql terminal
Sql :: sql cte example
Sql :: excel vba import data to sql server
Sql :: oracle all columns
Sql :: sql max value in column
Sql :: sql not exists
Sql :: Find the names of sailors who have reserved a red boat, and list in the order of age
Sql :: sql constraint to check date less than current date
Sql :: sql date between one week
Sql :: mysql select random rows large table