Question: Please write the SQL syntax only for the following questions! Thank you! Drop table Customers!!! Drop table Customers; 7. Now we'll recreate the customers table:
Please write the SQL syntax only for the following questions! Thank you! Drop table Customers!!! 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 JL Emps 9. Create a new table with these four columns from the existing Books table: ISBN, Cost, Retail, 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 L Emps table so that it can be restored. Restore the JL Emp table and verify that it is available again
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
