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. 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. Again, if youre on Oracle 12c, check the sequence name for the Idendity column and recreate it SELECT a.name AS tablename, b.name AS sequencename FROM sys.idnseq c JOIN obj a ON c.obj a.obj JOIN obj b ON c.seqobj b.obj Where a. I work with Toad for Oracle 12.1 for my database.
0 kommentar(er)
