{"id":10854,"date":"2019-03-21T20:34:36","date_gmt":"2019-03-21T20:34:36","guid":{"rendered":"https:\/\/dbtut.com\/?p=10854"},"modified":"2019-03-22T11:37:22","modified_gmt":"2019-03-22T11:37:22","slug":"what-is-view-in-sql-server-and-how-to-create-a-view","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/","title":{"rendered":"What is View in SQL Server and How To Create a View"},"content":{"rendered":"

We can briefly define View as a virtual table that does not physically store records, and is determined by a query. So, There is no more space need when creating views.<\/p>\n

Typically, we create view for complex queries that join multiple tables,\u00a0 to increase readability of our code. Thus, we do not have to write complex queries every time. Let’s clarify the topic by creating a view example. Click New View on the Views tab of a database as follows.<\/p>\n

Create a View Using SSMS<\/h1>\n

\"\"<\/p>\n

Double-click the tables, views, functions, or synonyms that we want to add to the view on the screen.<\/p>\n

\"\"<\/p>\n

After selecting the desired objects, we click Close and we select the relevant columns from the objects we selected. Then, the query that will create the View appears as in the following screenshot.<\/p>\n

\"\"<\/p>\n

You can save the view with CTRL + S. It’ll ask us what the name of the view will be. We will name it as ViewExample.<\/p>\n

\"\"<\/p>\n

When you click OK, you may receive an error as follows. The reason for this error is that the name of the view is the same as the name of one of the tables in the view.<\/p>\n

Cannot save a view\/funtion\/procedure that is self-referenced.<\/em><\/span><\/p>\n

\"\"<\/p>\n

As a workaround, you can save the view with another name.<\/p>\n

Create a View Using TSQL<\/h1>\n

If you want to create a view by using TSQL, you can use the following script.<\/p>\n

CREATE VIEW [dbo].[ViewExample]\nAS\nSELECT * FROM [dbo].[MyTable]\nGO<\/pre>\n
We can add indexes to the View. Indexed Views are known as the equivalent of Materialized View in Oracle. You can find details in the article “What is Indexed View in SQL Server and How To Create an Indexed View”.<\/p>\n\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
We can briefly define View as a virtual table that does not physically store records, and is determined by a query. So, There is no more space need when creating views. Typically, we create view for complex queries that join multiple tables,\u00a0 to increase readability of our code. Thus, we do not have to write …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":10866,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[2682,2680,2678,2677,2679,2681],"class_list":["post-10854","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-cannot-save-a-view-funtion-procedure-that-is-self-referenced","tag-what-is-a-view-in-database","tag-what-is-difference-between-view-and-table","tag-what-is-view","tag-what-is-view-in-sql","tag-what-is-view-in-sql-and-why-it-is-used"],"aioseo_notices":[],"yoast_head":"\nWhat is View in SQL Server and How To Create a View - Database Tutorials<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is View in SQL Server and How To Create a View - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"We can briefly define View as a virtual table that does not physically store records, and is determined by a query. So, There is no more space need when creating views. Typically, we create view for complex queries that join multiple tables,\u00a0 to increase readability of our code. Thus, we do not have to write …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-21T20:34:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-22T11:37:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c93f5308ee6a.png\" \/>\n\t<meta property=\"og:image:width\" content=\"663\" \/>\n\t<meta property=\"og:image:height\" content=\"321\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"What is View in SQL Server and How To Create a View\",\"datePublished\":\"2019-03-21T20:34:36+00:00\",\"dateModified\":\"2019-03-22T11:37:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/\"},\"wordCount\":294,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c93f5308ee6a.png\",\"keywords\":[\"Cannot save a view\/funtion\/procedure that is self-referenced.\",\"what is a view in database\",\"What is difference between view and table?\",\"What is view\",\"What is view in sql\",\"What is view in SQL and why it is used?\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/\",\"name\":\"What is View in SQL Server and How To Create a View - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c93f5308ee6a.png\",\"datePublished\":\"2019-03-21T20:34:36+00:00\",\"dateModified\":\"2019-03-22T11:37:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c93f5308ee6a.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c93f5308ee6a.png\",\"width\":663,\"height\":321},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is View in SQL Server and How To Create a View\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What is View in SQL Server and How To Create a View - Database Tutorials","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/","og_locale":"en_US","og_type":"article","og_title":"What is View in SQL Server and How To Create a View - Database Tutorials","og_description":"We can briefly define View as a virtual table that does not physically store records, and is determined by a query. So, There is no more space need when creating views. Typically, we create view for complex queries that join multiple tables,\u00a0 to increase readability of our code. Thus, we do not have to write …","og_url":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/","og_site_name":"Database Tutorials","article_published_time":"2019-03-21T20:34:36+00:00","article_modified_time":"2019-03-22T11:37:22+00:00","og_image":[{"width":663,"height":321,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c93f5308ee6a.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"What is View in SQL Server and How To Create a View","datePublished":"2019-03-21T20:34:36+00:00","dateModified":"2019-03-22T11:37:22+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/"},"wordCount":294,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c93f5308ee6a.png","keywords":["Cannot save a view\/funtion\/procedure that is self-referenced.","what is a view in database","What is difference between view and table?","What is view","What is view in sql","What is view in SQL and why it is used?"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/","url":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/","name":"What is View in SQL Server and How To Create a View - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c93f5308ee6a.png","datePublished":"2019-03-21T20:34:36+00:00","dateModified":"2019-03-22T11:37:22+00:00","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c93f5308ee6a.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c93f5308ee6a.png","width":663,"height":321},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/21\/what-is-view-in-sql-server-and-how-to-create-a-view\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What is View in SQL Server and How To Create a View"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/10854","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=10854"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/10854\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/10866"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=10854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=10854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=10854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}