I have been encountering an issue with SQL Developer for several years and it has persisted from previous versions until the current version.
I use the "Edit Table" screen (by right-clicking on a table and clicking Edit) to create and edit my tables. Sometimes I will add an Identity Column of "Type: Column Sequence" to my table (which auto-creates the trigger and sequence to enable auto inserting of consecutive numbers in my table's primary key). But it seems that every so often when I make a small change to a table (a change like deleting an unused column) it resets the Identity Column on my primary key back to "Type: None". I usually only discover this when an insert to that table fails because there is no number inserted into the primary key (because the Identity Column quit working). That's when I go into SQL Developer / Edit table and discover the Identity Column on my primary key has been set back to "Type: None". There is no person doing this, as I am the only one working on these tables.
I cannot figure out if this is a bug, or something about the functionality that I am missing?
It causes me lots of issues when it keeps causing my applications to throw errors. So I would love to figure this out.
Can anyone help?
Thanks!