/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 vote300 views1 answer
Subquery aggregation
SQL
1 vote310 views1 answer
Oracle sql first day of year
SQL
-1 vote295 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote301 views1 answer
Run mysql xampp shell
SQL
0 vote298 views1 answer
To change the database owner in SQL server
SQL
1 vote315 views5 answers
What is in operator in sql
SQL
7 votes371 views2 answers
3rd height salary sql
SQL
2 votes295 views1 answer
Get hour from date sql
SQL
0 vote303 views1 answer
Get sum sqlite android
SQL
0 vote310 views1 answer
Sql server information_schema temp tables
SQL

Share