This is mostly uses to suppress error messages in the database schema creation scripts. If you wish to delete a particular table but you are not entirely sure whether you have already deleted that table or if that table even exists then it is. outoflineconstraints ) The parameters or values mentioned in this syntax are: schemaname This is the schema that the table will be created under. Python Dictionaries Access Items Change Items Add Items Remove Items Loop Dictionaries Copy Dictionaries Nested Dictionaries Dictionary Methods Dictionary Exercise Python If.Else Python While Loops Python For Loops Python Functions Python Lambda Python Arrays Python Classes/Objects Python Inheritance Python Iterators Python Polymorphism Python Scope Python Modules Python Dates Python Math Python JSON Python RegEx Python PIP Python Try. In MySQL you can use IF EXISTS clause in the DROP TABLE statement. The syntax for the SQL create table statement is: CREATE schemaname.tablename ( columnname datatype NULL NOT NULL inlineconstraint DEFAULT defaultvalue.

Drop table if exists mysql