Deleting a Table

Description

If you have a table you don't need anymore, you can delete it.

To delete a table using SQL, use the following formula:
DROP TABLE TableName
 
The DROP TABLE expression is required and it is followed by the name of the undesired table. When you execute the statement, you will not receive a warning before the table is deleted.

Here is an example:
DROP TABLE StaffMembers;
 
 

No comments:

Post a Comment

Related Scripting

Related Posts Plugin for WordPress, Blogger...

Disqus for Functions