Can we pass null value in Unique Id

only one null we can insert

Shashidhar R1y

no

Shashidhar R1y

One null value possible, more than that is not possible

Nagaraju Kodavalla5y

Yes

krunal pande5y

Yes, we can keep null in unique column if it is nullable. Null is also a unique reconrd in the column. However, you can have only one null record as one null is only unique for that column.

Rijwan Ansari5y

Yes, we can.

The Unique constrain mainly use to restrict duplicate values insertion and ensure that column has a unique value. It will not allow you to enter the duplicate NULL value in the column but allow you to insert a unique(Single) NULL value in the column.

Kirtesh Shah5y

Yes You can .But only one Null value

Rahul Pal5y

Yes, But only once . Provided column value is nullable

Kiran Mohanty5y

Can we pass null value in Unique Id

8 Answers