If we try to drop a table that does not exist then MySQL issue an error as below. The above statement removes the Products table permanently from the database. To drop this Products table, you use the following statement. Suppose we have a table named Products in the mysqltutorial database as below. In this example, we will check an example of dropping a single table from the MySQL database. Let us check the different options of the MySQL DROP TABLE command using a few examples. RESTRICT and CASCADE – These optional parameters are reserved for the future release of MySQL.In this case, MySQL will not issue any error, simply it will not drop any table if the table does not exist. So, it is better to use this optional parameter along with the DROP TABLE statement. IF EXISTS – If the table does not exist, MySQL issue an error.This ensures that only the temporary table will be deleted. It is a good practice to use the schema name along with the table name as this ensures that the table dropped from the desired schema only. schema_name.table_name – you can optionally specify the schema_name or database_name while dropping a table.table_name – the name of the table that you need to drop.Here is the more generic syntax of the drop table command. Mysql> DROP TABLE schema_name.table_name The following are the syntax of dropping a table from MySQL. So, we need to be very careful before executing this command as the wrong table name provided to the statement can lead to the loss of data. This statement deletes the table structure along with the data completely from MySQL. MySQL allows us to drop a table from the database using the MySQL DROP TABLE statement.
#Mysql drop how to#
If there was also a permanent table called customers, this DROP TABLE statement would not delete it because TEMPORARY is specified.Summary: in this tutorial, you will learn how to drop a table using the MySQL DROP TABLE statement with syntax and examples.
This DROP TABLE example will only delete the temporary table called customers. DROP TEMPORARY TABLE IF EXISTS customers Drop Temporary Tableįinally, let's look at an example that shows how to use the DROP TABLE statement to drop a temporary table.
This example would delete the customers and suppliers tables and would not raise an error if one of the tables didn't exist. If we were worried that one of the tables doesn't exist and we don't want to raise an error, we could modify our DROP TABLE statement as follows: DROP TABLE IF EXISTS customers, suppliers This DROP TABLE statement example would delete two tables - customers and suppliers.
Let's look at an example where we want to drop more than one table using the DROP TABLE statement:įor example: DROP TABLE customers, suppliers This DROP TABLE example would delete the table called customers. Drop One Tableįirst, let's look at a simple DROP TABLE example that shows how to use the DROP TABLE statement to drop one table in MySQL. Let's look at an example that shows how to drop a table using the MySQL DROP TABLE statement. It has no impact or effect on the DROP TABLE statement but is included in the syntax to make porting the tables to different databases easier. If specified, the DROP TABLE statement will not raise an error if one of the tables does not exist. table_name1, table_name2 The tables to remove from the database, if removing more than one table in the DROP TABLE statement. table_name The name of the table to remove from the database. It specifies that only temporary tables should be dropped by the DROP TABLE statement. Parameters or Arguments TEMPORARY Optional.
#Mysql drop full#
However, the full syntax for the MySQL DROP TABLE statement is: DROP TABLE In its simplest form, the syntax for the DROP TABLE statement in MySQL is: DROP TABLE table_name
0 kommentar(er)
