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
Dig Deeper on Open source databases
Related Q&A from Mich Talebzadeh
Sybase expert Mich Talebzadeh explains how to log on in ASE.continue reading
Sybase expert Mich Talebzadeh gives fifteen reasons for why Sybase will definitely be around for years to come.continue reading
Sybase expert Mich Talebzadeh explains the syntax for user-defined Sybase functions.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.