support for the TRUNCATE statement

[Former user]

it'd be nice to support TRUNCATE on those dbms that support it, for example when table.delete() is called without any filters. it's standard sql, and more efficient than a normal .delete(), so why not? :)

[Mike Bayer]

usually because its easy enough to just say execute("truncate table"). its more "efficient" because it bypasses all integrity checks and triggers so its not a lever you should be pulling often - its more of an administration command.

[Mike Bayer]

oh if you mean, issue TRUNCATE when one says delete(), definitely never. wow talk about surprise behavior.

[Mike Bayer]

as you can see here http://en.wikipedia.org/wiki/Truncate_(SQL) , its behavior is anything but consistent. implicitly commits on oracle, for example.