What is view? Types of views?use of views?how to create view(syntax)?

Showing Answers 1 - 8 of 8 Answers

DIPTENDU HUI

  • Jan 28th, 2006
 

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

2.There are mainly two type of views

a) Simple View

b) Complex View

apart from that we can also subdivided views as UpdatableViews and Read only Views.

Lastly there is an another view named as Materialized Views.

3. View is used for the purposes as stated below:

a) Security

b) Faster Response

c) Complex Query solve

4.Syntax is :

Create or replace view([olumn1],[column2]...)

as

Select column1,column2...

from table_name

[where condition]

[with read only],[with check option]

  Was this answer useful?  Yes

Brajendra Nath Vimal

  • Mar 5th, 2006
 

View:- View is the vertual or logical or the duplicate copy of the original table with schema parts only.Types Of Views:- i)Readable Viewii) Updatable ViewCreation of view:- Syntax:- Create view As Select A1,A2,.........,An From T1,T2,.............,Tn Where

  Was this answer useful?  Yes

A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other words, there is no stored file that direct represents the view instead a definition of view is stored in data dictionary.
Growth and restructuring of base tables is not reflected in views. Thus the view can insulate users from the effects of restructuring and growth in the database. Hence accounts for logical data independence.
There are two type of views:
1,simple view
2,complex view

  Was this answer useful?  Yes

srvardhan

  • Nov 29th, 2007
 

The dynamic result of one or more relational operations operating on base relations to produce new relation.

creating view: create view View_Name as select query.

Basically we use views for 1. to reduce the complexity in writing queries  --> go with view resolution
2. To improve performance --> go with materializing view  (remember if the frequency of executing select query is more than the frequency of updating then only go with this)
 
Rajavardhan Sarkapally

  Was this answer useful?  Yes

View:
A view is a list of columns or a series of records retrieved from one or more existing tables, or as a combination of one or more views and one or more tables.

Types of Views:
a)
DataBase View
b) Help View
c) Projection View
d) Maintenance View


Use of views
A view provides the mechanism to hide certain data from the view of certain users.


Syntax:
use XXX (your database name)
GO
CREATE VIEW view1(view name)
AS
SELECT -------
-----------------(your query)
-----------------

  Was this answer useful?  Yes

sachinbbau

  • Feb 1st, 2011
 

A view is a virtual table, which provides access to a subset of columns from one or more tables. It is a query stored as an object in the database, which does not have its own data.

  Was this answer useful?  Yes

raman sharma

  • Mar 2nd, 2012
 

view is called a temporarily table when we want to create the copy of any table as requirement column then we use the view
syntax-------------
create view (view name) as select (* or column name) from (table name);

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions