Sql

-- 'DROP TABLE' followed by the name of the table you would like
-- to drop.
DROP TABLE `test_table`;

DROP TABLE tablename;

DELETE FROM `table_name` [WHERE condition];

DROP TABLE IF EXISTS table1;

delete table query

DROP TABLE <table name;
e.g. DROP TABLE students;

DROP TABLE countries;
Code language: SQL (Structured Query Language) (sql)

mysql --silent --skip-column-names -e "SHOW TABLES" DB_NAME | xargs -L1 -I% echo 'DROP TABLE `%`;' | mysql -v DB_NAME

DROP TABLE table;
DROP TABLE IF EXISTS table;
DROP TABLE table1, table2, ...

PREVIOUS	NEXT

Code Example
Sql :: drop all foreign key constraints mysql
Sql :: sql update alias
Sql :: nvl2 syntax
Sql :: how to print longest name in sql
Sql :: mysql reset auto increment to 1
Sql :: sql today at midnight
Sql :: create sqlite database in laravel
Sql :: spark sql convert string to date
Sql :: get first 2 letter in sql
Sql :: update date of birth in sql
Sql :: mysql one week ago
Sql :: postgres describe query
Sql :: how to add default constraint in mysql
Sql :: oracle ora-00054 causes
Sql :: how to check schema privileges in oracle
Sql :: postgres in operator with comma separated values
Sql :: ORACLE SHOW AVAILABLE DB LINK
Sql :: sql string starts with
Sql :: mysql db size
Sql :: how to use like in sql
Sql :: sql update from different table
Sql :: ajouter une clé etrangere mysql
Sql :: grant access on table in oracle
Sql :: delete all content in table mysql
Sql :: postgres alter table owner
Sql :: trigger in postgresql to change incoming entry
Sql :: mysql backup query
Sql :: update single sql column
Sql :: convert date to dd/mm/yyyy sql
Sql :: get server date mysql