Re: SQL Statement for Resetting Serial Column ?
L.Shaw wrote:
>
> I thought it was possible to amend the table with data to an integer
> column, then change it back to serial with a specified starting integer
> using dbaccess.
>
> Might be wrong though its a long time since I thought I did it.
>
> "Ramdas Gopinath" <rgopi@rankin.com> wrote in article
> <5oc0c3$mn7@cssun.mathcs.emory.edu>...
> > 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.
You don't even need to do that. You CAN use ALTER TABLE to change
the next number.
Cheers,
--
Mark.
+------------------------------------------------------------------+
|Mark D. Stock - The West Solutions Group http://www.west.co.za |
| The Informix FAQ is at http://www.iiug.org |
|mailto:marks@west.co.za +-----------------------------------------+
|Tel: +27 11 803 2151 |If it doesn't work, force it! |
|Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!|
|Cell: +27 83 250 2325 |Well, that's how I code anyway! |
+------------------------+-----------------------------------------+