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? Thanks -Zavier -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
