Drop Table in SQL get rid of an object or table from the database. Using a drop Query get rid of all the rows deleted from the table and the structure is removed from database. The Drop table cannot get it back, once you run the drop Query for a table.
Understand with Example
The Tutorial illustrate an example from Drop Table. To grasp this example, we give you a simple demonstrative example to understand Drop Query in SQL. The create table statement create a table 'Stu_Table' with field attribute and data type respectively.
Create Table Stu_Table
SQL statement to create table:
Insert Data into Stu_Table
The insert into add the records or rows to the table 'Stu_Table'.
SQL statement to insert data into table:
Records in the table:
Drop Table Query
The Drop Table Query delete the table 'Stu_Table' from database. The Table 'Stu_Table' is no longer to be present in database.