[Tutor] Truncating a Table

Tim Golden mail at timgolden.me.uk
Fri May 11 17:54:52 CEST 2007

Leon Keylin wrote:
> Thanks Tim for a fast reply.
> The return gives me 0 Rows Truncated message and when I look at the table,
> every record is still there.
> There are no foreign keys on the table and no errors.
> Andreas asked if I should commit after, should I? I didn't think I 
> needed to
> but I can try that.

Commits shouldn't make any difference
at all to truncation -- that's the point of
it, unless the interface lib is actually
holding back from *issuing* the cursor command
until you commit. (Though I doubt it).

Does it work in Query Analyzer (or any other
means you have of issuing the command)? Does
truncation work on any other table?


More information about the Tutor mailing list