Skip to content

View

IT Notes → Database → SQL @ December 22, 2020

View is nothing but parsed SQL statement which fetches record at the time of execution.

There are mainly two types of views:

  1. Simple View.
  2. Complex View.

Also

  1. Updatable Views.
  2. Read only Views.

 

Finally, we have Materialized Views.

View is used for the purposes as stated below:

  1. Security.
  2. Faster response.
  3. Solve complex query.

 

Syntax is:

CREATE or REPLACE view ([olumn1] [column2]...)
AS
SELECT column1 column2...
FROM tablename
[WHERE condition]
[WITH read only] [WITH check option]
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x