Answers

Question and Answer:

  Home  SQL Server Views

⟩ Explain the functionalities that views support?

Views can subset data in a table

They can join multiple tables into one virtual table

Views can provide security and decrease complexity

They save space because only their definition is stored.

They can also be used to create abstraction

Materialized views are commonly used in data warehousing. They represent a snapshot of the data from remote sources.

Views can create other calculated fields based on values in the real underlying tables

 184 views

More Questions for you: