Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Renaming Columns
I know it's been posted that columns cannot be renamed, but I was wondering
if anyone has tried this by directly modifing the sys.col$ table. I'd do it
myself, but I'm more of a programmer than a DBA and we don't have a very good
backup system going yet. I've done something similiar to this, modifying the
on delete cascade flag for constraints. I update the refact column in the
sys.cdef$ table. It works, although it seems to take a while for the changes
to take effect. I was wondering if this would also work for the column
names.
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 09:45:38 CDT
![]() |
![]() |