English subtitles

← Views - Intro to Relational Databases

Get Embed Code
4 Languages

Showing Revision 3 created 05/25/2016 by Udacity Robot.

  1. Whether you can update or
  2. delete from views at all, depends on the database system.
  3. In SQLite, you just can't.
  4. It doesn't support it.
  5. But in PostqreSQL, you can update or delete on simple views,
  6. like ones that select just particular rows or columns from a large table.
  7. But not from views that use drawing, aggregations, or other functions.
  8. The change to the view will effect the underlying table that it's a view of.
  9. So, the answer is that yes, you can update or
  10. delete rows from some views but not others.