0
678views
Views in SQL
1 Answer
0
6views

Views in SQL : A view is nothing more than SQL statement that is stored in the database with an associate name.

  • A view is actually a composition of a table in the form of a predefined SQL query.

  • A view can be contain all rows of a table or selected rows from a table.

  • A view may be created from or more tables.

Creating view.

Syntax :

create view viewname as

{SQL select query}

example

consider a customer table as.

cust (id, name, email, city, state, phone)

create view cust_info as.

select id, name, email,

from cust.

This will show only little information about customer.

we can execute normal query OD view to view data.

eg. select * from cust_info

Uses of view :

  • Hiding some information from user.

  • Predefined queries to make writing other queries simple.

Implementation of view :

Views are implemented as temporary tables in database.

Updating a view :

As views are stored as temporary relations we can do insertion, deletion and updation.

Please log in to add an answer.