|Re: [ib-support] Renaming a Table
> Is there a simple way to rename a table. It has various constraints andUnfortunately, or fortunately depending on your viewpoint, this is not
> triggers etc but I need to rename it cos it is casuing a lot of confusion.
possible easily. You need to drop all constraints, triggers and stored
procedures that reference the table, create a new table, transfer the
records into the new table, modify and reapply all the triggers, etc. to
reflect the new table name. It's a lot of work initially, but you'll be
happier in the end, trust me. <g>
"Never trust a computer you can't throw out a window."