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:
“The near explains the far. The drop is a small ocean. A man is related to all nature. This perception of the worth of the vulgar is fruitful in discoveries. Goethe, in this very thing the most modern of the moderns, has shown us, as none ever did, the genius of the ancients.”
—Ralph Waldo Emerson (1803–1882)
“How often we read that the enemy occupied a position which commanded the old, and so the fort was evacuated! Have not the school-house and the printing-press occupied a position which commands such a fort as this?”
—Henry David Thoreau (1817–1862)