Is there a way to truncate the table?

[devsarvesh92]

No description provided.

[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:

piccolo/piccolo/table.py

Line 1449 in 9d1ab2d

async def drop_db_tables(*tables: t.Type[Table]) -> None:

[sarvesh-deserve]

Thanks @dantownsend