A NEW DBA DOUBT - Can we add NULL value in USI ?

General
SSM
Fan

A NEW DBA DOUBT - Can we add NULL value in USI ?

Dear All, 

I have a weird situation, where one my application team asks us to add a column to an existing table, the new column will get populated after 2 months. Until two months they want to keep the values to Null, after which they shall load the data into table which will be unique, they are asking if we can declare this column as USI ? 

My answer was "No" want to see if someone has any work around ? 

 

Thanks,

SSM. 

Tags (1)
1 REPLY
Enthusiast

Re: A NEW DBA DOUBT - Can we add NULL value in USI ?

SSM,

No is the correct answer, (unique violation). why not just build the USI after the data has been populated in 2 months?

Rglass