By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,649 Members | 2,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,649 IT Pros & Developers. It's quick & easy.

chnage use identity column to sequence

P: n/a
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

--
Message posted via http://www.dbmonster.com
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 12 '05 #2

P: n/a
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).

edurne murgiondo via DBMonster.com wrote:
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.