HomePagev2 Forums SQL Discussions Views in database Reply To: Views in database

  • Badri Rajasekhar Reddy Rajasekhar Reddy

    Member
    September 18, 2020 at 2:32 pm

    There are two types of database views Dynamic and Static views.

    1.Dynamic views contain data from one or two tables and automatically include all columns of the specific table or tables. Dynamic views can be updated dynamically when related or extended objects are created or modified .when creating a dynamic view with data from two tables, you must ensure that both tables have same PRIMARYKEYCOLSEQ columns or contain unique indexes with the same column name in the same order.

    2.Static views contain data from several tables and the necessary columns of these tables must be specified in the SELECT and WHERE clauses of the static view. Dynamic views can be updated manually when related objects or extended objects are created or modified.

    Importance of views:

    To the database, the view is the same as a real table for a user with the set of column names and row data. SQL creates a custom views by giving the view the same name as a table name and store a definition of the view in the database and views is used for security purposes in the database and acts as an intermediate between real tables schema and programmability.