Hi Eric,
Just curious: What is your use case? Why do you need a nullable primary key column? Dave *From:* Eric Owhadi [mailto:[email protected]] *Sent:* Tuesday, February 2, 2016 11:43 AM *To:* [email protected] *Subject:* RE: nullable primary key index column? Thank you Anoop for the prompt response. It won’t help for my use case because I have more than one null. I will therefore assign a fake value to represent NULLs in that column. Eric *From:* Anoop Sharma [mailto:[email protected]] *Sent:* Tuesday, February 2, 2016 1:30 PM *To:* [email protected] *Subject:* RE: nullable primary key index column? cqd ALLOW_NULLABLE_UNIQUE_KEY_CONSTRAINT ‘ON’; then create table with nullable pkey col. only one null value is allowed. *From:* Eric Owhadi [mailto:[email protected]] *Sent:* Tuesday, February 2, 2016 11:27 AM *To:* [email protected] *Subject:* nullable primary key index column? Dear Trafodioneers, I am wondering if it is possible to use a composite primary key with the first column making up the primary key composite being nullable? If yes, is there any restriction, like only one row can be null for that nullable column? Thanks in advance for the help, Eric
