DROP sql command to delete table field constraints database and multiple tables

SQL DROP to remove table

We have seen how to remove records from a table by using truncate sql command. Now we will learn how to use DROP query command to delete a table or a column or some other properties associated with the table. Let us start with deleting a Column of a table by DROP command.

Delete Column

ALTER TABLE `content`   DROP `dt`;

Here content is our table name and dt is one of the field of this table. By this command we can delete the field dt of the table content.

Deleting a Table

We can use DROP command to remove a table inside the database. Now here is the code to delete the table content.

DROP TABLE content

Checking before deleting

We can check whether table is there or not before giving any delete command. Without ensuring the presence of table ( non existence table ) delete command will generate an error message.

DROP TABLE IF EXISTS `content`;

Deleting multiple tables

We can use drop command to delete more than one table. Here is the command to remove 4 tables.

DROP TABLE `content`, `content_admin`, `content_cat`, `content_cmt_post`;

The above command will delete four tables.

Dropping a unique constraints

We can use DROP sql command to remove unique constraints associated to any column, here is an example.

ALTER TABLE 'content_cat' DROP INDEX  'cat_id'

The above command will remove the unique index associated with cat_id field of content_cat table
We can also use DROP command to delete a complete database. Here is the sample code

DROP DATABASE TEST

PHP Code to Drop table

MySQLi database connection string

<?Php  require "config.php";// Database connection    $query="DROP TABLE dt_tb ";  if($connection->query($query)){    echo "Table deleted.";  }else{  echo $connection->error;  }  ?>

SQL Insert command using set option to add records to MySQL table
SQL having with group by in a query for MySQL tables
GROUP_CONCAT to concatenated group data to a string by adding distinct, order by SUM to display as single column
SQL GROUP BY query to count records within a group & sub group of data
DISTINCT SQL Tutorial to get unique records from tables
DROP sql command to delete table field constraints database and multiple tables

destination source:https://www.plus2net.com/sql_tutorial/sql_drop.php