I created one table having 3 columns namely(no,name,dept).i want to make column 'no' as primary key, but it is not created with not null column.is it possible to alter a column having null into not null..........
frankly ,i avoid using altobj as very little details are available in infocenter which makes it even more difficult to understand.
i had gone through Serge article but still too hard to grasp(at least for me )
well i suppose altobj does all those steps in the background (export/create/import).
neways thanks a lot for help.
MEENA: if u want to avoid all these steps u can directly go to control center and alter table from null to not null and then create PK.