Question

explain the types of views in a database​

Answer 1

Answer:

System Defined Views System-defined Views are predefined Views that already exist in the Master database of SQL Server.

Information Schema View In SQL Server we have twenty different schema views. These are used to display information of a...

Catalog View Catalog Views were introduced with SQL Server 2005. These are used to show database self-describing...

Dynamic Management View Dynamic Management Views were introduced in SQL Server 2005. These Views give the administrator...

Answer 2

Explanation:

There are two types of database views: dynamic views and static views. Dynamic views can contain data from one or two tables and automatically include all of the columns from the specified table or tables. Dynamic views are automatically updated when related objects or extended objects are created or changed.