Zavier Sheran wrote: > > I have a table with a primary index that was created like this: > > CREATE TABLE "DBA"."CARS_USED" > ( > "RECORD_ID" Fixed (10,0) NOT NULL DEFAULT SERIAL (1) > } > > Every time I insert a record without giving a value to > 'record_id', it auto > inserts a value that increases by 1 with every new INSERT. > > Exactly what I wanted, but where do I reset this sequence to 1? > > This sequence does not show up un 'Sequences' in the SQL Manager. > > How do I know the name of the Sequence? Is there a default > name created in > context with the name of the field? >
There is no chance to reset this value. This would corrupt the usual usage of a sequence as it is defined to show the insertion sequence into a table and to assure the uniqueness of the corresponding column. I do not know the reason for your wish to reset it. The only chance is to re-create the table with a new serial and insert the current values into the newly created table. Elke SAP Labs Berlin > > Thanks > > -Zavier > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
