Message-Id: <10681.122165@fatcity.com> From: "Mohan, Ross" Date: Wed, 15 Nov 2000 14:59:35 -0500 Subject: Resetting HWM This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C04F3E.32FC0C30 Content-Type: text/plain; charset="iso-8859-1" Folks, Anyone heard of a built-in or utility that lets me reset a table's HWM? I *know* there is something out there that let's me do this short of a truncate or drop/create, but I must have been hitting the crack pipe too hard lately and can't remember. TIA Ross Mohan (Certifiable) ------_=_NextPart_001_01C04F3E.32FC0C30 Content-Type: text/html; charset="iso-8859-1" Resetting HWM

Folks,

Anyone heard of a built-in or utility that lets me
reset a table's HWM?

I *know* there is something out there that let's
me do this short of a truncate or drop/create, but
I must have been hitting the crack pipe too hard
lately and can't remember.

TIA

Ross Mohan
(Certifiable)