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.

प्रश्न

Can the CREATE OR REPLACE statement be used to redefine the artist_title view?

संभावित उत्तर

Yes, as long as the label column comes at the end.

No, because the new query requires a JOIN with the labels table.

No, because a new column that did not exist previously is being added to the view.

Yes, as long as the label column has the same data type as the other columns in artist_title

अभ्यास

Redefining a view

निर्देश 1/2

प्रश्न

संभावित उत्तर

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}अभ्यास

निर्देश 1/2

प्रश्न

संभावित उत्तर

अभ्यास