Hello,
anyone could explain why we have two different statements when adding a constraint on an existing table ?
If I need to add a primary key constraint to a column belonging to an existing table I use:
alter table tab1 add constraint tab1_id_cst primary key( id )
but if I want to add a NOT NULL constraint, the same syntax does not work, I need to use alter table modify instead
Why ?
Thank you !