Follow this topic

Last answered:

18 Nov 2022

Posted on:

17 Nov 2022

0

Dropping customers table

in SQL / FOREIGN KEY constraint - Part II

While trying to drop the customers table i get the following error Error Code 1051. Unknown table 'sales.customers'

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

18 Nov 2022

0

Hi Sebastian!
Thanks for reaching out.

Make sure you execute the script consecutively. You must first create the table in order to drop it or fill it with data.

Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

Harsha Dharmabandu

1

14

Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty

Sivarajan Sivakumar

0

14

Cannot insert 999903 into the dept_emp table?

5

12

Resolved: M query fetch time increased after creating an index for the salaries table!

0

12

SELECT * FROM customers;

Ashakah Onome Andrew

0

10

Resolved: Salaries table is empty, showing Null

0

10

Error after Error: Can't create a table this time

0

8

cant't create table in sql

0

6

Drop table from the database