Redefining a view
Unlike inserting and updating, redefining a view doesn't mean modifying the actual data a view holds. Rather, it means modifying the underlying query that makes the view. In the last video, we learned of two ways to redefine a view: (1) CREATE OR REPLACE
and (2) DROP
then CREATE
. CREATE OR REPLACE
can only be used under certain conditions.
The artist_title
view needs to be appended to include a column for the label
field from the labels
table.
This exercise is part of the course
Database Design
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
