Sql Query To Drop Table

To drop or delete an existing created table and all its data, then we can use a ' DROP TABLE ' statement.

In below query

1^st line - It shows that regions table exist, using select statement

2^nd line - The regions table has been a drop

3^rd line - It shows that table doesn't exist (no such table: regions), which means regions table has been a drop

Database

Theme

Enter - Select * from table_name;

Output

#	Program	Language
1	Sql Query To Use a ' SELECT ' statement with OR Operator	SQL
2	Sql Query to use a Not Null Constraint	SQL
3	Sql Case Sensitive Example 2	SQL
4	Sql Query To Use a Unique Key	SQL
5	Sql Query To Use a ' SELECT ' statement with GROUP BY Clause	SQL
6	Sql Query To Insert The Record In The Table By Defining The Column Name	SQL
7	Sql Example to create table and insert data into it	SQL
8	Sql Example To Rename Table Name Using Alter Command	SQL
9	Sql Query To Use a ' SELECT ' statement with DISTINCT() function.	SQL
10	Sql Query to Delete or Drop View	SQL
11	Sql Query To Add Column Using ADD With ALTER Command	SQL
12	Sql Query To Use a Inner Joins	SQL
13	Sql Query to retrieve data using Order By in Random Order	SQL
14	Sql Query To Update Multiple Column	SQL
15	Sql Query to retrieve data using Order By in Ascending Order	SQL
16	Sql Case Sensitive Example 1	SQL
17	Sql Query To Use a ' SELECT ' statement with LIMIT	SQL
18	Sql Case Sensitive Example 4	SQL
19	Sql Query To Use a ' SELECT ' statement with AVG() function.	SQL
20	Sql Update Query Without Where Condition	SQL
#	Program	Language