SQL DROP

DROP DATABASE

Syntax

DROP {DATABASE | SCHEMA} [IF EXISTS] db_name
		    

Examples

DROP DATABASE IF EXISTS sql_hr; -- 删库
		    

DROP TABLE

Syntax

DROP [TEMPORARY] TABLE [IF EXISTS] [/*COMMENT TO SAVE*/]
    tbl_name [, tbl_name] ...
    [WAIT n|NOWAIT]
    [RESTRICT | CASCADE]
		    

Examples

DROP TABLE IF EXISTS emplyees ; --删表