Gives the possibility to truncate specific tables

Why it matters

This feature enables users to efficiently truncate multiple tables in a database that match a pattern, simplifying management tasks and reducing the need for manual truncation of individual tables.

How to use it

Use the TRUNCATE TABLE command combined with the LIKE keyword to specify a pattern for the tables to be truncated. For example:

TRUNCATE TABLE database_name LIKE 'pattern%';