/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

0 vote247 views1 answer
Show table structure mysql console
SQL
8 votes270 views1 answer
Oracle search code in packages
SQL
5 votes241 views1 answer
How to check nls timestamp format in oracle
SQL
22 votes266 views3 answers
SQL CHEATSHEET
SQL
0 vote274 views1 answer
Get initials name in sql
SQL
0 vote249 views1 answer
Mysql query single row
SQL
0 vote284 views2 answers
Oracle chain rules
SQL
0 vote246 views1 answer
Postgresql conectar
SQL
0 vote264 views1 answer
How to query without duplicate rows in sql
SQL
0 vote265 views2 answers
MySQL PARTITION BY month automatically
SQL

Share