Originally posted by kris109
You can rename it straight out:
rename old_sequence to new_sequence;
It would say table renamed but you can ignore it. Your sequence will be renamed.
Gee, this is a nice trick! So simple, yet so elegant.
And as I can see it now from the documentation it is even documented! So besides tables and views (for which most of us was aware of, I gues) you can use RENAME also for sequences and for private synonyms.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?