|
|
Posted by Robert Klemme on 11/29/06 08:50
On 28.11.2006 22:29, Jim C wrote:
> !!!
> Bad side effect: TRUNCATE TABLE resets the identity column to 1. Dumb,
> poorly documented feature. Needs to have an optional NO IDENTITY RESET
> clause.
Ooops, sorry for forgetting that.
> So I have to use DELETE instead, that's ok.
Or you just leave the table alone and let it grow.
robert
Navigation:
[Reply to this message]
|