Re: Renaming primary and /or unique keys

Maxim Demenko wrote:

> SQL> create table my_emp as select * from emp;
> SQL> create index my_emp on my_emp(empno);
> SQL> alter table my_emp add constraint my_emp check(deptno<100);

So far it's clear, but that does not involve renaming an existing primary key and index.

I was out for an example of how to disable/reenable and rename both the constraint and index as you originally suggested.

Jens Received on Thu Jul 13 2006 - 15:06:26 CDT