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

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
https://www.plus2net.com/sql_tutorial/sql_student_dump.php
Tutorial on Delete table
https://www.plus2net.com/sql_tutorial/sql_drop.php


#SQL #DeleteTable #queryDelete #plus2net #MySQLDelete #DeleteQuery #DeleteIfExists #plus2net

Тэги:

#Delete_table_query #DROP_table #MySQL_delete_table #Checking_if_table_exists_before_deleting #DROP_table_if_exists #warning_message_if_table_is_not_exists #Delete_multiple_tables #Deleting_script #Query_to_delete_multiple_tables_from_database

Скачать видео