Add unique key constraint on existing column Sql query

sql Share on :

ALTER TABLE Employee
ADD UNIQUE (ID);

Best JSON Validator, JSON Tree Viewer, JSON Beautifier at same place. Check how cool is the tool

If you have a table named 'Employee' for example in your database and you want to add UNIQUE Constraint on that column. You can achieve that using above query

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

MySQL Foreign key constraint
SQL query to copy one column values to another column in same table
Add Unique Constraints on Column in MySQL
SQL Server query to get table structure and column information
SQL Query to delete rows that have different Ids or column values
SQL Server query to add auto increment field
Drop table SQL query

Create your own code snippets and search them using our portal and chrome extension

Programming Feeds

Learn something new everyday on Devsheet

Important Links

Join Devsheet Create new snippet Ask a Question Write an article Online JSON Viewer