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

질문

가능한 답변

연습 문제