Hi,
I have a project that I'm updating and it uses views. Can someone tell me what a view is and its purpose?
Thanks,
theChris
Hi,
I have a project that I'm updating and it uses views. Can someone tell me what a view is and its purpose?
Thanks,
theChris
A view is nothing more than a representation of an SQL query.
They have many uses.
One use to to restrict a user to see only certain columns in a table.
Another use is to join several tables, then show the user relevant rows so that they can
be seen without the need of a complex SQL query.
To add to lewy's excellent response, a View is a sort of "Virtual Table" that can be made of the columns of several other tables. They are very useful because of that.
jmurrayhead
If you agree, give me rep. If my post helped you, click "Thanks".
If you like it here...throw us a few bones to help support us.
Thanks for the responses, guys! Very helpful!
Bookmarks