Answers for "drop all tables except one table sql"

drop all data from tables

DELETE FROM my_table;			-- all rows, needs a COMMIT to validate
TUNCATE TABLE my_table;			-- all rows, quicker, no possible roolback

Posted by: Guest on May-08-2021

delete all records from table except sql

delete from yourTableName where yourColumnName NOT
IN(‘yourValue1’,‘yourValue2’,‘yourValue3’,.........N);

Posted by: Guest on May-14-2020

Code answers related to "drop all tables except one table sql"