Are tables shared across views?


In the update methods for views a table name is defined. Is this table name unique to the view or is it shared across views? For example if I have view1 with tableX and view2 with tableX are they the same physical table (storage) or are the different?

I had always assumed they are not shared and independent but would be good to confirm my mental model.


Yes, the tables are independent. The table reference is internal to the view, and the underlying storage is associated with the view id.

1 Like