Toad World® Forums

Issue with Schema Browser CREATE TABLE script and identity column

Toad for Oracle 12.12.0.39. Oracle documentation shows that the KEEP/NOKEEP option is valid for a sequence object but is not one of the options in the identity clause for CREATE TABLE columns. If you create a table with an identity column, Oracle creates a random name sequence object and ties that to the column. Problem I am running into is Toad appears to be adding in the KEEP/NOKEEP option setting to the CREATE TABLE script available through the Schema Browser. If you try to run that script, you get an error due to this inclusion.