One scenario where you might want to use a view (although the element of amending the database schema of 3rd party package rang alarm bells...), is where you want to change a database schema.
For example you want to replace "tableA" with a new "tableB", tableB contains the columns of tableA plus several additional ones. Here existing functionality using tableA can still be supported by creating a view on tableB with the name of "tableA"
No comments:
Post a Comment