Sebastian Tau
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

Sivarajan Sivakumar
0
18
Cannot insert 999903 into the dept_emp table?
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
lalit yadav
7
12
Resolved: M query fetch time increased after creating an index for the salaries table!
Ramu Ganta
0
12
Resolved: SELECT * FROM customers;
Francois Chouinard
1
10
Can you show the instructions to reproduce dept_manager_dup table?
Matt Birch
0
10
Error after Error: Can't create a table this time
Ashakah Onome Andrew
0
10
Resolved: Salaries table is empty, showing Null
Snoor Salihi
0
10
Resolved: Drop table from the database
Longyin Li
0
8
cant't create table in sql
Geetanjali Juneja Upadhyay
0
6
15. sql subquires--Can you please help to find out why in the video you are using the dept_emp table
Abdul Rehman
0
6
Resolved: Why you are using different query editor for like new query for table creation of sales then new que
Pawee Chiranothai
0
6
Why does drawing data from dept_manager_dup table get different results?