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

Unit Navigation IconBasic database queries

Unit Navigation IconSQL Insert, Delete and Update

LO Navigation IconInserting tuples

LO Navigation IconDeleting tuples

LO Navigation IconUpdating tuples

LO Navigation IconeLSQL Exercise 'Insert, Delete und 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 tuples

The DELETE FROM command removes one or more rows (tuples) of a table (relation). The WHERE-clause specifies which tuples have to be deleted. If it is missing, all tuples are deleted!

The syntax is:

DELETE FROM <Tablename>
WHERE <Condition>;

Deleting tuples
importantNOTE: If DELETE FROM is used without WHERE, all datasets of this table are deleted. This is irreversible in most systems.
Top Go to previous page Go to next page