Skip to main content

Create a unique constraint

MSSQL

To create a unique constraint on a table, use below query.
alter table <tableName> add constraint <constraintName> unique(<column>);

MySQL

 To create a unique constraint on a table, use below query.
alter table `<tableName>` add unique (column(s));

Comments

Popular posts from this blog

Get all constraints in Oracle

 To get all the constraints created in Oracle database, use below query.              SELECT * FROM USER_CONSTRAINTS; If you want to get the constraints  created for a particular user then use below SQL query.              SELECT   *   FROM  USER_CONSTRAINTS where owner = 'userName';