On Wed, Apr 10, 2013 at 6:27 PM, Doug Meil <[email protected]>wrote:
> > re: "truncate is supposed to be more like a "delete_all"," > > In an RDBMS an "truncate" doesn't do "delete all", it actually whacks the > underlying files to clear the table (or a particular partition, if you > happen to have an RDBMS that supports partitioning). > You've missed the important part "requiring just the ability to delete all the rows in the table" on purpose? Do you think that truncate should stay as it today requiring the same rights as "CREATE TABLE"? in this case, a use may be able to delete rows from the table but not run truncate the table because it doesn't have enough rights to recreate it.
