Is there a way to truncate the table?

[dantownsend]

Piccolo doesn't have a truncate command built in at the moment - you can use delete:

await MyTable.delete(force=True)

Or raw SQL to access the truncate command:

await MyTable.raw('TRUNCATE my_table')

[dantownsend]

I'll probably add this when I get time, as I do think would be nice.

Sometimes along the lines of this:

https://github.com/piccolo-orm/piccolo/blob/9d1ab2d492c26a677d689823f85d12303f548bfa/piccolo/table.py#L1449

[sarvesh-deserve]

Thanks @dantownsend