chnage use identity column to sequence

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

edurne murgiondo - 31 Mar 2005 15:35 GMT

I have a table with a column as identity. I don't know how can migrate a
identity column to a normal column using sequence.
Thnaks

Reply to this Message

bwmiller16@yahoo.com - 31 Mar 2005 16:05 GMT

I think you are going to have to export the data, drop the table,
re-create the table without IDENTITY, re-load the data.

Then create your sequence, do your 'grant usage', set the sequence to
the correct value, then modify your inserts, etc. to reference the
sequence.

Reply to this Message

Sean McKeough - 31 Mar 2005 16:35 GMT

If you're on stinger, you can drop the identity attribute for a column,
and change it's generation attributes (see the alter table statement in
the SQL ref).

> I have a table with a column as identity. I don't know how can migrate a
> identity column to a normal column using sequence.
> Thnaks

Reply to this Message