Re: SQL Statement for Resetting Serial Column ?
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>
Except if the table has data in, and the MAX(col) is already higher
than the required next number.
In that case the ALTER TABLE works but does nothing!
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! |
+------------------------+-----------------------------------------+