Auto Increment Key fields
Can we add auto increment fields similar to SQL server
Starting at 1 and going up by 1 for each record ?
Jawahar
Row Number automatically does this, or you can use Sequence to start at a specific value.
Yes row number does this for generation of data, but for SQL exports if you’re creating the table along with data generation, the table does not establish that it is a PRIMARY KEY or AUTOINCREMENT
A non-related issue too, note the screenshots! Datetime types offer a formatting option for Unix epoch timestamps, which are long integers. the generator keeps the DATE type for the column definition, which is not a compatible type.