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!

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!

Take Hint (-30 XP)

Exercise

Deleting all the records from a table

Instructions