Related Commands
Deleting all rows from a table can be very time consuming. Some DBMS offer a TRUNCATE TABLE command that works a lot quicker, as it only alters metadata and typically does not spend time enforcing constraints or firing triggers.
DELETE only deletes the rows. For deleting a table entirely the DROP command can be used.
Read more about this topic: Delete (SQL)
Famous quotes containing the words related and/or commands:
“Women stand related to beautiful nature around us, and the enamoured youth mixes their form with moon and stars, with woods and waters, and the pomp of summer. They heal us of awkwardness by their words and looks. We observe their intellectual influence on the most serious student. They refine and clear his mind: teach him to put a pleasing method into what is dry and difficult.”
—Ralph Waldo Emerson (1803–1882)
“There are no more ideologies in the authentic sense of false consciousness, only advertisements for the world through its duplication and the provocative lie which does not seek belief but commands silence.”
—Theodor W. Adorno (1903–1969)