DROP

Definition:

To delete something in the DBMS.

---

Command Syntax:

DROP DATABASE database_name;

• delete a existing database in the DBMS

DROP TABLE table_name;

• delete a table from the using database

DROP INDEX index_name;

• delete an index
• index_name can be founded via SHOW CREATE TABLE - SQL statement

ALTER TABLE table_name DROP field_name/constraint_name;

• delete a field/constraint from the table
• constraint_name can be founded via SHOW CREATE TABLE - SQL statement

---

'DROPing my brain.'By secondary 6 student