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.

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.

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.

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.

Answer / sachin ladda

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

Answer / kalyan

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

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

can a table be moved to different filegroup? : Sql server administration

0 Answers  

Explain tablesample?

0 Answers  

What's new in sql management studio for sql server? : sql server management studio

0 Answers  

What are the different types of Indexes available in SQL Server?

0 Answers  

What is de-normalization and when do you do it?

3 Answers  

How many primary keys are possible in a table?

0 Answers  

When columns are added to existing tables, what do they initially contain?

0 Answers  

Define Unique Key?

0 Answers   HCL,

How do I find query history in sql server?

0 Answers  

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

What is a DBMS, query, SQL?

0 Answers   Maveric,