{"id":305,"date":"2016-05-24T22:29:07","date_gmt":"2016-05-25T05:29:07","guid":{"rendered":"https:\/\/database.guide\/?p=305"},"modified":"2020-02-14T16:31:55","modified_gmt":"2020-02-14T23:31:55","slug":"how-to-create-a-view-in-sql-server","status":"publish","type":"post","link":"https:\/\/database.guide\/how-to-create-a-view-in-sql-server\/","title":{"rendered":"How to Create a View in SQL Server"},"content":{"rendered":"

To create a view<\/a> in SQL Server<\/a>:<\/p>\n

    \n
  1. Open a new query by clicking\u00a0the New Query<\/kbd> button in the SSMS<\/abbr><\/a> toolbar<\/li>\n
  2. Type or paste\u00a0a\u00a0CREATE VIEW<\/kbd> statement (example below)<\/li>\n
  3. Run the script<\/li>\n<\/ol>\n

    The view will now be created in the database<\/a>. You will be able to see it under the Views node in the Object Explorer.<\/p>\n

    You can now use SELECT<\/kbd> statements against the view in future queries.<\/p>\n

    Below are screenshots of the above steps.<\/p>\n

    <\/p>\n

    Open a New Query<\/h2>\n

    Open a new query by clicking\u00a0the New Query<\/kbd> button in the SSMS<\/abbr> toolbar:<\/p>\n

    \"Screenshot<\/a>
    The SSMS with the New Query button highlighted.<\/figcaption><\/figure>\n

     <\/p>\n

    Type or paste\u00a0a\u00a0CREATE VIEW statement<\/h2>\n

    This will start with CREATE VIEW (view_name) AS<\/code> followed by the contents of the view.<\/p>\n

    Here’s an example:<\/p>\n

    CREATE VIEW ToDoList AS\r\nSELECT\tTasks.TaskName, Tasks.Description\r\nFROM\tStatus INNER JOIN\r\n\t\t\tTasks ON Status.StatusId = Tasks.StatusId\r\nWHERE\t(Status.StatusId = 1)\r\n<\/pre>\n
    Run the script<\/h2>\n
    \"Screenshot<\/a>
    A SQL view called “ToDoList” has just been created, and now appears in the Object Explorer.<\/figcaption><\/figure>\n
    Run the View<\/h2>\n
    You can run a view by selecting from it. Use the SELECT<\/kbd> statement in the same way that you’d use it when selecting the contents of a table.<\/p>\n
    \"Screenshot<\/a>
    Run a view by using a SELECT statement.<\/figcaption><\/figure>\n
    So a view is basically a pre-written query that is stored on the database. Instead of\u00a0typing the whole query out every time you want to run it, you can save it in a view. Then all you need to do is run\u00a0a simple SELECT<\/kbd> against that view.<\/p>\n","protected":false},"excerpt":{"rendered":"
    To create a view in SQL Server: Open a new query by clicking\u00a0the New Query button in the SSMS toolbar Type or paste\u00a0a\u00a0CREATE VIEW statement (example below) Run the script The view will now be created in the database. You will be able to see it under the Views node in the Object Explorer. You … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[10,12,24],"class_list":["post-305","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-how-to","tag-sql-server","tag-views"],"_links":{"self":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/305","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/comments?post=305"}],"version-history":[{"count":10,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/305\/revisions"}],"predecessor-version":[{"id":370,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/posts\/305\/revisions\/370"}],"wp:attachment":[{"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/media?parent=305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/categories?post=305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/database.guide\/wp-json\/wp\/v2\/tags?post=305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}