Re: SQL Statement for Resetting Serial Column ?
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.