Are these both queries the same?

[Anon]

CREATE UNIQUE INDEX payment_file_idx_nub ON dos_payment_file_nub
(loan_id);

ALTER TABLE dos_payment_file_nub
ADD (PRIMARY KEY(loan_id)
USING INDEX);

I thin so, as a primary key is always a not null unique index - right?

thx and cu

[[deleted]]

Yes a primary key is unique,not null and indexed, but a column that is unique, not null and indexed is not neccessarily a primary key.