Monday, August 3, 2015

SQL tutorial - lesson 25 - View

A view is a virtual table.

A view can be created based on two or more tables.

What ever data is present in the view cannot be modified. but you run queries on it .

syntax:

create view "view name" as SELECT column1, column2, column3..... FROM table_name  WHERE  "condition";

No comments:

Post a Comment