/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

14 votes229 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
15 votes232 views3 answers
Find duplicate keys in mysql
SQL
0 vote254 views1 answer
Stored procedure function relation
SQL
0 vote244 views1 answer
Find how many tables in database sql query
SQL
0 vote232 views1 answer
View to table
SQL
9 votes224 views3 answers
Oracle undo usage by session
SQL
1 vote230 views1 answer
Raw query must include primary key
SQL
10 votes223 views5 answers
Between keyword in sql
SQL
0 vote201 views1 answer
SQL server select to get sum of hours
SQL
11 votes241 views2 answers
Mysql set safe mode off
SQL

Share