> Is there a simple way to rename a table. It has various constraints and
> triggers etc but I need to rename it cos it is casuing a lot of confusion.
>

Unfortunately, or fortunately depending on your viewpoint, this is not
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>

Woody (TMW)

"Never trust a computer you can't throw out a window."
-Steve Wozniak