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
If you agree with me... click the icon!
If my post solved your problem, click the button in the lower right-hand corner of the post.

If you like it here...throw us a few bones to help support us.

Join our Folding team: DeveloperBarn Folding

Thanks for the responses, guys! Very helpful!