Discuss "SQL Server Views" in the Microsoft SQL Server forum.

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
Did I help you out? Make me popular by clicking the icon!

If you found a post helpful, please click the button in the lower right-hand corner of the post.

Powered by ASP.Net

Thanks for the responses, guys! Very helpful!