/SQL/Truncate table

Truncate table

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

1 vote345 views2 answers
Postgres cast as decimal
SQL
0 vote376 views1 answer
Tsql cte in a transaction
SQL
0 vote316 views1 answer
Mysql workbench procedure
SQL
5 votes314 views1 answer
Oracle find foreign key dependencies
SQL
0 vote311 views1 answer
Add plugins to mysql workbench
SQL
0 vote342 views1 answer
The package java.sql is not accessible
SQL
0 vote365 views1 answer
Oracle sql developer closed connection
SQL
0 vote349 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote330 views1 answer
Rabbitmq ui not working
SQL
3 votes324 views2 answers
Mysql create timestamp column
SQL

Share