Question: please write the SQL and query I Write a query to Drop table Customersill Here's what to write: Drop table Customers; 7. Now we'll recreate

please write the SQL and query
please write the SQL and query I Write a query to
I Write a query to Drop table Customersill Here's what to write: Drop table Customers; 7. Now we'll recreate the customers table: Use fields customerkt, lastname, firstname, address, city, state, zip, referred, region. Add Not null constraints to lastname and firstname, Table Management 8. Rename the Employees table as J. Emps 9. Create a new table with these four columns from the existing Books table: ISBN, Cost, Retall, and Category. The name of the ISBN column should be ID and the other columns should keep their original names. Name the new table Book.Pricing, 10. Delete the book.pricing table permanently so that it isn't moved to the recycle bin. Then delete the ). Emps table so that it can be restored. Restore the ). Emptable and verify that it is available again

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!