GITTA-Logo
PDF Version of this document Search Help

Lesson Navigation IconStructured Query Language SQL

Unit Navigation IconSQL overview

Unit Navigation IconCreation and modification of tables

LO Navigation IconCreate tables

LO Navigation IconChanging the table structure

LO Navigation IconDeleting tables

Unit Navigation IconBasic database queries

Unit Navigation IconSQL Insert, Delete and Update

Unit Navigation IconUsage of SQL

Unit Navigation IconSummary

Unit Navigation IconRecommended Reading

Unit Navigation IconBibliography

Unit Navigation IconMetadata


GITTA/CartouCHe news:


Go to previous page Go to next page

Deleting tables

With DROP TABLE an existing table can be deleted. The data and structure of the table are deleted.
The command has the following syntax:

DROP TABLE <Table name>;

importantAttention: With DROP TABLE the table structure is deleted with all the data. In most cases, this cannot be undone!

Top Go to previous page Go to next page