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:
“No being exists or can exist which is not related to space in some way. God is everywhere, created minds are somewhere, and body is in the space that it occupies; and whatever is neither everywhere nor anywhere does not exist. And hence it follows that space is an effect arising from the first existence of being, because when any being is postulated, space is postulated.”
—Isaac Newton (1642–1727)
“I do not speak with any fondness but the language of coolest history, when I say that Boston commands attention as the town which was appointed in the destiny of nations to lead the civilization of North America.”
—Ralph Waldo Emerson (1803–1882)