Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
DROP
On this page

DROP

DROP

In SQL, the DROP statement is used to remove or delete database objects, such as tables, or databases.

Here are a few common uses of the DROP statement:

  1. Drop a table

    You can delete a table in sql by using the drop command.

    DROP TABLE table_name;

    By specifying the name of table you want to delete, this command will delete the table and its associations.

  2. Drop a database

    A database can also be deleted by using the DROP command. All the table of the database will also be deleted.

    DROP DATABASE database_name;

As DROP statement result in the permanent deletion of data and database objects it's a good practice to double-check and ensure that the object being dropped is indeed the one intended, and that any necessary backups have been made.

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page

DROP