What is the main advantage of views?
If we delete the table in which our view based then view will exist?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Midhun TpPosted Oct 28, 2016, 6:48 AM
Bikesh SrivastavaPosted Oct 28, 2016, 8:12 AM
aditya immadiPosted Oct 28, 2016, 7:34 AM
1. Views can hide complexity
If you have a query that requires joining several tables, or has complex logic or calculations, you can code all that logic into a view, then select from the view just like you would a table.
2. Views can be used as a security mechanism
A view can select certain columns and/or rows from a table, and permissions set on the view instead of the underlying tables. This allows surfacing only the data that a user needs to see.
3. Views can simplify supporting legacy code
If you need to refactor a table that would break a lot of code, you can replace the table with a view of the same name. The view provides the exact same schema as the original table, while the actual schema has changed. This keeps the legacy code that references the table from breaking, allowing you to change the legacy code at your leisure.
Muhammad AbdullahPosted Oct 28, 2016, 7:28 AM
aditya immadiPosted Oct 28, 2016, 7:24 AM