WHAT IS VIEW IN DATABASE?

Monaj Singh

Total Post:48

Points:240
Posted by  Monaj Singh
 1125  View(s)
Ratings:
Rate this:
  1. Rajesh Goswami

    Post:85

    Points:425
    What is View in Database?

    A view can be thought of as either a virtual table or a stored query. Unless a view is indexed, its data is not stored in the database as a distinct object.

    Syntax:
    CREATE VIEW view_name AS
    SELECT column_name(s)
    FROM table_name
    WHERE condition

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!