1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Databases in Python

Exercise

Deleting all the records from a table

Often, you'll need to empty a table of all of its records so you can reload the data. You can do this with a delete statement with just the table as an argument. For example, in the video, Jason deleted the table extra_employees by executing as follows:

delete_stmt = delete(extra_employees)
result_proxy = connection.execute(delete_stmt)

Do be careful, though, as deleting cannot be undone!

Instructions

100 XP
  • Import delete and select from sqlalchemy.
  • Build a delete statement to remove all the data from the census table. Save it as delete_stmt.
  • Execute delete_stmt via the connection and save the results.
  • Hit 'Submit Answer' to select all remaining rows from the census table and print the result to confirm that the table is now empty!