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