Closed Thread
Results 1 to 4 of 4

Thread: SQL Server Views

  1. #1
    theChris
    theChris is offline
    Awaiting Email Confirmation theChris is an unknown quantity at this point theChris's Avatar
    Join Date
    Mar 2008
    Posts
    14
    Rep Power
    3

    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
    theChris, March 23rd, 2008 06:32 PM
  2. #2
    lewy
    lewy is offline
    Barn Newbie lewy is on a distinguished road lewy's Avatar
    Join Date
    Mar 2008
    Posts
    40
    Rep Power
    3

    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.
    lewy, March 23rd, 2008 07:08 PM
  3. #3
    jmurrayhead
    jmurrayhead is online now
    The Barnfather jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead has much to be proud of jmurrayhead's Avatar
    Join Date
    Mar 2008
    Location
    Washington, D.C.
    Posts
    2,347
    Blog Entries
    9
    Rep Power
    19

    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, March 23rd, 2008 07:10 PM
    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.

  4. #4
    theChris
    theChris is offline
    Awaiting Email Confirmation theChris is an unknown quantity at this point theChris's Avatar
    Join Date
    Mar 2008
    Posts
    14
    Rep Power
    3

    Thanks for the responses, guys! Very helpful!
    theChris, March 23rd, 2008 07:35 PM
Closed Thread
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


SEO by vBSEO