[Tutor] Truncating a Table
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