Re: renaming database constraint names

On Aug 2, 8:42 am, Shirley Cohen <shirley.co...@gmail.com> wrote:
> Hi,
>
> I was wondering if anyone has ever tried to rename the database
> constraint names that are created by Django? In particular, I'm
> working with Oracle and would like to rename all the SYS_C* constraint
> names in my Django schema to something more descriptive. If anyone has
> any experience with that and has some suggestions on how to do it, I'd
> love to hear from you.
>
> Thanks,
>
> Shirley

In a dbshell:

ALTER TABLE tablename RENAME CONSTRAINT old_name TO new_name;

HTH,
Ian

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.