SQL drop

drop is a command in sql which is used to delete a table/column/index/database.

To drop a table

DROP table table_name;

To drop a database

DROP database database_name;

To drop a table column

ALTER TABLE table_name
DROP COLUMN column_name ;

Must Read:

some database systems don't allow deleting a column.

Aptitude / Reasoning / Interview
Physical education & sports