SQL delete table command by using DROP query and before deleting checking if TABLE exists

preview_player
Показать описание
We can delete table by using this query
DROP table table_name
If the table is not existing then we will get error message, if we don’t want to error message then we can use this query. This query will generate warning ( not error ) message if the table student is not available.
DROP table IF EXISTS student
We can delete multiple tables by using this command
DROP TABLE student1, student2, student3, student4

Copy of student mysql dump
Tutorial on Delete table

#SQL #DeleteTable #queryDelete #plus2net #MySQLDelete #DeleteQuery #DeleteIfExists #plus2net
Рекомендации по теме