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

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

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 Databases Questions!