Dharmendra
New Member
Hi,
Can anyone confirm the below question regarding primary index.
CREATE abc.
ASSIGN abc.a = ""
abc.b = ""
abc.c = 1
abc.d = "1".
Here field b in the table abc is primary index and allowed null values multiple times.
So my question is does primary index allows null values as like unique index does(only one null value).
If this is allowed then the differences between unique and primary index are
1) the unique index allows unique record and primary allows multiple.
2) Only one primary is allowed and multiple unique indexes are allowed for a table.
And also primary unique index acts like unique index but at the same time it also acts like primary index for a table.
Please confirm.
Can anyone confirm the below question regarding primary index.
CREATE abc.
ASSIGN abc.a = ""
abc.b = ""
abc.c = 1
abc.d = "1".
Here field b in the table abc is primary index and allowed null values multiple times.
So my question is does primary index allows null values as like unique index does(only one null value).
If this is allowed then the differences between unique and primary index are
1) the unique index allows unique record and primary allows multiple.
2) Only one primary is allowed and multiple unique indexes are allowed for a table.
And also primary unique index acts like unique index but at the same time it also acts like primary index for a table.
Please confirm.