TMai_handsonAssignmentPage 536-537 .docx - TU B mai Hand-on assignment 1 CREATE VIEW contact AS SELECT contact phone FROM publisher 2 CREATE OR REPLACE

TMai_handsonAssignmentPage 536-537 .docx - TU B mai Hand-on...

This preview shows page 1 out of 1 page.

TU B mai Hand-on assignment 1. CREATE VIEW contact AS SELECT contact, phone FROM publisher; 2. CREATE OR REPLACE VIEW contact AS SELECT contact, phone FROM publisher WITH READ ONLY; 3. CREATE FORCE VIEW homework13 AS SELECT col1, col2 FROM firstattempt; 4. DESC homework13; 5. CREATE VIEW reorderinfo AS SELECT isbn, title, contact, phone
Image of page 1

You've reached the end of your free preview.

Want to read the whole page?

  • Fall '18
  • LarryA.Ray
  • Foreign key, Prime number, Articles with example SQL code, RENEE SMITH, 9876543210

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture