ADO TutorialLesson 69Free preview

ADO Delete

This lesson is part of ASP · All levels

Summary

Deleting lines using the DELETE query... WHERE must always be accompanied by a condition not to delete the entire table. Before running a large DELETE, do a data verification and consider a transaction or backup copy. Another option is TRUNCATE TABLE which deletes the entire line at once without any condition.

Key points

Delete from the WHERE condition table removes the row that meets the condition.
Delete without WHERE deletes all the data lines.
TRUNCATE TABLE deletes the entire line quickly without condition.
Save or verify important data before a major deletion operation.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.