Regarding the constraints


Regarding the constraints

Hi Guys,

I have a Question here..

I have  created a table Tab_test with some constraints

check (Emp_Sal>10000) and UPI on Emp_Id.

and loaded data from the source which contains duplicates..

So the duplicate values are loaded to an error table and now I wanted to change/modify the constraints of base table.

Is it possible to alter ..?

Note: I deleted the base table data.

Thanks in advance..



Re: Regarding the constraints

Your table is empty, you can make a change.

You cannot alter a populated primary‑indexed table to have a different set of primary index columns.