If we give any constraint for multipe columns and we want to drop constraint of specific column then what is the query for that? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

If we give any constraint for multipe columns and we want to drop constraint of specific column then what is the query for that?

If I give unique constraint for 2 columns and if I want to delete unique constraint of specific column and if I write "Alter table table_name drop constraint c_name unique" then it will delete all unique constraint from that table, but I want to delete of one specific column.

4th Aug 2021, 5:05 AM
Harshanand Raykar
Harshanand Raykar - avatar
0 Answers