Toad World® Forums

Auto Increment field in table

How do I create an Auto Increment field in table using the Create table button and using the Load from file option?

Just go through the “Load from file” option without it, then…

If you are on Oracle 12 or newer, you can choose “Identity” in the Default/Identity column on the grid where you set up the columns. Oracle allows only one of these per table.

If you have an older version of Oracle, then the only way to do this is with a trigger and sequence. To set that up, after the table is created, find it in the schema browser, right-click on it, and choose Add -> Sequence/Trigger Pair.

My screen shot didn't appear from my first reply. Retrying...