Delete records from a table

- [Instructor] Deleting records in SQLite…is very similar to modifying them.…Let's say we want to delete all records…in our users table that are active.…We would start by setting up our selection criteria.…Recall that this is just a string that contains…there where portion of our SQL statement.…Next, we would execute the delete method.…Passing in the table name, the selection string,…and, in this case, null, as we don't have any placeholders…in our selection string that we will want to replace.…

Let's say this is our state before we execute the deletion.…Once the previous code is run, this will leave us with only…one record, Joe, as he's the only user in the table…who is not active.…One thing to keep in mind is that if you have…multiple tables associated with each other,…you will need to handle removing all of the records…in each table by yourself.…Otherwise, you will end up with orphaned records…and that's just sad.…

You can, however, configure SQLite to notify you…when you make changes that violate…your foreign key relationships.…