Re: SQL Statement for Resetting Serial Column ?

You cannot use the Alter table for resetting the Serial Column. You can alter and add a Serial Column, but the table should not have any Data at that time. Gopi. On 19 Jun 97 at 17:58, Richard Thomas wrote: } At 08:31 19/06/97 -0400, you wrote: } >Can someone give me a good example of how to use the alter table } >statement for resetting a serial column next number. } > } } Example: } } table is called 'tab' } column is called 'col' } required next number = 123 } } alter table tab modify col serial(123); } } <flamebait> } Correct me if I'm wrong, everybody!!! } </flamebait> } } Cheers, } } Richard. } } } -------------------------------------------------- Ramdas Gopinath E-mail: rgopi@rankin.com 602-997 6996 X125 Fax: 602-997 4256 --------------------------------------------------