1.

What Is A Sql View? Briefly Explain The Use Of Views?

Answer»

A SQL view is a virtual table built from other TABLES or views.

Views are USED to:

  1. hide columns or rows,
  2. the results of computed columns,
  3. hide complicated SQL SYNTAX,
  4. LAYER built-in functions,
  5. provide a level of indirection between APPLICATION programs and tables,
  6. assign different sets of processing permissions to tables, and
  7. to assign different sets of triggers to the same table.

A SQL view is a virtual table built from other tables or views.

Views are used to:



Discussion

No Comment Found