Sequence Editor

midnit · Post by **midnit** » Thu 03 Nov 2011 19:32

Why can't I edit the "Initial" value of a sequence using the editor? Its grayed out and I couldn't find any options to allow me to do so, I had to script a drop and create...which is easy enough but...why have an editor. Am I missing something?

.jp · Post by **.jp** » Fri 04 Nov 2011 07:44

You can't edit the "Initial" value of a sequence because it is not supported in the ALTER SEQUENCE statement.
So, you should recreate your sequence if you want to change the "Initial" value.

vu · Post by vu » Fri 04 Nov 2011 11:08

If you want us to implement sequence re-creation in visual editor, please add this feature suggestion to our forum on UserVoice.
http://devart.uservoice.com/forums/1328 ... for-oracle