This is the current SQL script (if this may help): ALTER TABLE MYSCHEMA.TBLEMPLOYEEĭROP TABLE MYSCHEMA.TBLEMPLOYEE CASCADE CONSTRAINTS įirst of all, your sequence should start with the max value + 1 from the table e.g. In the Default / Virtual / Identity settings.īut I can't seem to do the same when I do Alter Table instead of Create Table.Īnd since I already have some data in the TBLEMPLOYEE, I want to avoid creating a new table and re-inserting the data if possible. For instance, using Create Table and in the newly created Column, we could set Default / Virtual / Identity settings as Identity:Īnd Toad will show a UI with bunch of settings to do that:Īnd will be automatically translated to something like: (START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9999999999999999999999999999 CACHE 20 NOCYCLE ORDER NOKEEP) I know that in Toad we can do it when we create a New Table with that behavior. Now I want to change the Column ID such that it will have auto-incremented ID when I add a new data to the Table. Weve another test instance db g but the connection. The connection from toad to db is very slow. HI, weve toad 8 for oracle and our DB is 9i. Otherwise its a specific TOAD issue, which should be checked in a TOAD forum. If its the same behaviour we can further analyze. I have a Table called TBLEMPLOYEE which already contain some data in it and having Column Name called ID whose data values are increasing from 1 to N. Reproduce the issue with a native Oracle tool like sqlplus. I work with Toad for Oracle 12.1 for my database.
0 kommentar(er)
