Database Views

Database views joins two or more tables into a single table, and are used to simplify reporting for the end user

Capabilities

  • Report on fields form two or more tables
  • Join clauses create a virtual table
  • Ability to limit which fields are returned
  • Records returned are read-only and cannot be modified

Simplify reporting

  • Database Views are used to simplify reporting when data is coming from two or more tables.
  • Tables are joined into a single table which becomes the source of data for a report.
  • There is a rich set of database views already defined in the base instance.
    • The join determines the solution set.
    • For example, if you define a database view that specifies a Left join for Table A to Table B, a query returns all entries in Table A, even if there are no related records in Table B.

Type of join is IMPORTANT

Depending on the type of join clause used to define the Database View, the Order view is quite important. This means that whichever table has a lower Order field value is considered the left-hand table.

results matching ""

    No results matching ""