All Forums Database
rvvs999 3 posts Joined 11/13
15 Jan 2014
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..
Raja

 

Raja_KT 1246 posts Joined 07/09
15 Jan 2014

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.
Cheers,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.