Page 1 of 1

Sequence Editor

Posted: Thu 03 Nov 2011 19:32
by midnit
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?

Posted: Fri 04 Nov 2011 07:44
by .jp
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.

Posted: Fri 04 Nov 2011 11:08
by vu
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