Ask the Expert

Data roots when queried through 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?

Requires Free Membership to View

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 first published in March 2006

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: