SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can we rename the system generated constraint_name as per our convenience ?

933937Apr 29 2012 — edited May 1 2012

I created a table by
CREATE TABLE table_name AS (SELECT * FROM existing_table_name WHERE 1=2);
and got the all constraints of the existing table with default names. I want to rename those constraints as per current table data.

thank you in advance

Edited by: 930934 on Apr 29, 2012 8:51 AM

This post has been answered by Himanshu Binjola on Apr 29 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 29 2012

Added on Apr 29 2012

11 comments

1,170 views