Can we add a new column having multiple null values to already existing unique keys in the table?
There is a table having unique key on a combination of five columns. A new column has been added in the table, hence older records is all null for the newly added columns. I need to add this new column as part of the already existing unique key. Is it possible? if yes, please provide syntax too.