Question: please write a query/sql 1 Write a query to Drop table Customersill Here's what to write: Drop table Customers; 7. Now we'll recreate the customers
please write a query/sql
1 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 customer, 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 Polclor. 4 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 JL.Emr table 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
