/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 vote109 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote114 views1 answer
Get substract count sql
SQL
4 votes149 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote117 views1 answer
How to get button for every record from mysql
SQL
51 votes207 views6 answers
Change column name sql
SQL
0 vote141 views1 answer
Sql date with year
SQL
1 vote117 views3 answers
Rows, INSERT INTO
SQL
4 votes110 views1 answer
Postgres delete last row
SQL
7 votes113 views1 answer
Oracle pagination query offset
SQL
0 vote101 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL

Share