Skip to main content

Posts

Showing posts with the label unique constraint MySQL

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));