DeveloperBarn Forums

DeveloperBarn

Programming & IT forum

SQL Server Views

This is a discussion on SQL Server Views within the Microsoft SQL Server forums, part of the Databases category; Hi, I have a project that I'm updating and it uses views. Can someone tell me what a view is ...

Go Back   DeveloperBarn Forums > Databases > Microsoft SQL Server

  #1  
Old March 23rd, 2008, 06:32 PM
Awaiting Email Confirmation
 
Join Date: Mar 2008
Posts: 14
Rep Power: 0
theChris is an unknown quantity at this point
Default SQL Server Views

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
  #2  
Old March 23rd, 2008, 07:08 PM
Barn Newbie
 
Join Date: Mar 2008
Posts: 40
Rep Power: 2
lewy is on a distinguished road
Default

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.

Comments on this post
jmurrayhead agrees: Good answer! Good answer!
theChris agrees: thanks
  #3  
Old March 23rd, 2008, 07:10 PM
jmurrayhead's Avatar
The Barnfather
 
Join Date: Mar 2008
Real name: Jason
Location: Washington, D.C.
Posts: 1,953
Blog Entries: 8
Rep Power: 15
jmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud ofjmurrayhead has much to be proud of
Default

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

  #4  
Old March 23rd, 2008, 07:35 PM
Awaiting Email Confirmation
 
Join Date: Mar 2008
Posts: 14
Rep Power: 0
theChris is an unknown quantity at this point
Default

Thanks for the responses, guys! Very helpful!
Closed Thread

  DeveloperBarn Forums > Databases > Microsoft SQL Server

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 10:23 PM.


Copyright ©2008-2010, DeveloperBarn

Content Relevant URLs by vBSEO 3.3.2