Accidentally dropped table, how to restore it?

Q&A DQ Courses
, ,
#1

Screen Link:

My Code: 

SELECT * FROM customer

What I expected to happen:
Customer table displayed, or at least an error saying it’s too long and I need a limit

What actually happened:

(sqlite3.OperationalError) no such table: customer
[SQL: SELECT * FROM customer]
(Background on this error at: http://sqlalche.me/e/13/e3q8)

I’m pretty sure I accidentally dropped the table when I thought something else was using that table name and messing up my results. I can’t complete the screen without this table.

#2

Hi @holly,

Welcome to the Community!

Try to press the Restore Initial Code button (two rounded arrows to the right of the green button Submit Answer) and then re-run your code.

#3

Thanks for the welcome and the tip. I had already tried that a couple times when the issue occurred. I took a break for the day and now that I’ve come back hours later, it’s working again! Guess it needed a chance to reset from my accidental destruction :sweat_smile:

190-4, Even after using DROP to remove the customer_usa view, I am getting the below mentioned error
#4

Ah, then it required a reload of computer. Next time you don’t have to wait the whole day but start using it right after reloading :wink: