/SQL/Truncate all tables

Truncate all tables

Truncate table

TRUNCATE TABLE table;

3

Truncate all tables

SELECT Concat('TRUNCATE TABLE ',table_schema,'.',TABLE_NAME, ';') 
FROM INFORMATION_SCHEMA.TABLES where  table_schema in ('db1_name','db2_name');

0

Source: stackoverflow.com

Similar codes

0 vote220 views1 answer
Get created time of database psql 8
SQL
0 vote266 views1 answer
Sql date with year
SQL
12 votes224 views1 answer
Env var for setting password for root user mysql docker hub
SQL
2 votes233 views1 answer
Get first 2 letter in sql
SQL
5 votes251 views1 answer
Invalid column name sql
SQL
1 vote262 views1 answer
Mysql last year
SQL
6 votes221 views2 answers
Return columns from table sql
SQL
1 vote229 views1 answer
Sql server reseed single table
SQL
0 vote255 views1 answer
Oracle dynamic select into
SQL
11 votes250 views3 answers
How to get last row of table in sql
SQL

Share