mSQL Tutorial 3

The "Drop" clause

Now that we know how to insert data into the fields of a table we should look at how to remove that table if we should need to.

Here is the format for the drop clause:

DROPT TABLE table_name

So an example would be:

DROP TABLE emp_details

In this example we are simply telling mSQL to remove the table "emp_details" and all data stored within its fields.

Pretty simple huh? Let's move on to The "Delete" Clause.