Are tables shared across views?

1

Hi,

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.

Thanks,
Si

2

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