Q
Problem solve Get help with specific problems with your technologies, process and projects.

Data roots when queried through a view

Sybase expert Mich Talebzadeh explains where data is derived from when queried from a view.

When we query data through a view, is the data stored in the view or the table? Is data from a view stored in the database?

A VIEW is a compiled object. Data is always stored in the databases tables and through view you are looking at the underlying data

SELECT a.col1, b.col2 from TABLE_A a, TABLE_B b WHERE a.col3 = b.col4

is equivalent to:

CREATE VIEW a_view
AS
SELECT a.col1, b.col2 from TABLE_A a, TABLE_B b WHERE a.col3 = b.col4

SELECT * FROM a_view

This was last published in March 2006

Dig Deeper on Linux servers

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

SearchServerVirtualization

SearchCloudComputing

Close