What is a view?

Answers were Sorted based on User's Feedback



What is a view?..

Answer / sandip gele

In view,we can create virtual table with the columns from
different tables by relation between them, we can use this
view as a table for selecting a data but we can't use view
to insert data.

Is This Answer Correct ?    2 Yes 0 No

What is a view?..

Answer / yuvaraja

SQL: VIEWS

------------------------------------------------------------
--------------------

A view is, in essence, a virtual table. It does not
physically exist. Rather, it is created by a query joining
one or more tables.

Creating a VIEW
The syntax for creating a VIEW is:

CREATE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;



For example:

CREATE VIEW sup_orders AS
SELECT suppliers.supplier_id, orders.quantity, orders.price
FROM suppliers, orders
WHERE suppliers.supplier_id = orders.supplier_id
and suppliers.supplier_name = 'IBM';

This would create a virtual table based on the result set
of the select statement. You can now query the view as
follows:

SELECT *
FROM sup_orders;



Updating a VIEW
You can update a VIEW without dropping it by using the
following syntax:

CREATE OR REPLACE VIEW view_name AS
SELECT columns
FROM table
WHERE predicates;



For example:

CREATE or REPLACE VIEW sup_orders AS
SELECT suppliers.supplier_id, orders.quantity, orders.price
FROM suppliers, orders
WHERE suppliers.supplier_id = orders.supplier_id
and suppliers.supplier_name = 'Microsoft';



Dropping a VIEW
The syntax for dropping a VIEW is:

DROP VIEW view_name;

For example:

DROP VIEW sup_orders;



Frequently Asked Questions

------------------------------------------------------------
--------------------

Question: Can you update the data in a view?

Answer: A view is created by joining one or more tables.
When you update record(s) in a view, it updates the records
in the underlying tables that make up the view.

So, yes, you can update the data in a view providing you
have the proper privileges to the underlying tables.


------------------------------------------------------------
--------------------

Question: Does the view exist if the table is dropped from
the database?

Answer: Yes, in Oracle, the view continues to exist even
after one of the tables (that the view is based on) is
dropped from the database. However, if you try to query the
view after the table has been dropped, you will receive a
message indicating that the view has errors.

If you recreate the table (that you had dropped), the view
will again be fine.

Is This Answer Correct ?    2 Yes 0 No

What is a view?..

Answer / guest

If we have several tables in a db and we want to view only
specific columns from specific tables we can go for views.
It would also suffice the needs of security some times
allowing specfic users to see only specific columns based on
the permission that we can configure on the view. Views also
reduce the effort that is required for writing queries to
access specific columns every time.

Is This Answer Correct ?    1 Yes 0 No

What is a view?..

Answer / prakash.s

Views are simply called as mirror table or virtual table.
Feild of one table can be updated inside the view.
Updation of more than one table inside the views is not
possible.

Is This Answer Correct ?    1 Yes 0 No

What is a view?..

Answer / sachin ladda

In view,we can list out different column from different
table in one virtual table..

Is This Answer Correct ?    2 Yes 1 No

What is a view?..

Answer / kalyan

A View is a named virtual table that is defined by a query
and used for a table

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)

8 Answers  


What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,


How to know whether our backup is succesfully taken?

1 Answers  


What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  


Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,






what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  


What is a non clustered primary key?

0 Answers  


What are the differences between “row_number()”, “rank()” and “dense_rank()”?

0 Answers  


SQL Server Architecture ?

0 Answers   IBM, Sapient,


What is the maximum size of column in sql server?

0 Answers  


Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  


Explain what are the restrictions while creating batches in sql server?

0 Answers  


Categories