/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 vote209 views1 answer
Drush run sql select
SQL
8 votes206 views1 answer
Mac restore mysql database command line
SQL
0 vote192 views1 answer
Get only first row mysql
SQL
0 vote220 views1 answer
Mysql select smaller of two values
SQL
0 vote247 views2 answers
Temp tables in sql server
SQL
0 vote225 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote246 views1 answer
Python mysql check if database exists
SQL
13 votes220 views2 answers
Get date from now() mysql
SQL
0 vote209 views1 answer
Change schema of all tables postgres
SQL
0 vote218 views1 answer
What is ssrs and ssis in sql server
SQL

Share