<?xml version="1.0" encoding="utf-8"?>
<html>
  <head>
    <meta http-equiv="X-UA-Compatible" content="IE=8" />
    <link rel="stylesheet" href="../../../css/main.css" type="text/css" />
    <link rel="stylesheet" href="../../../css/jquery.treeview.css" />
    <script src="../../../script/jquery.js" type="text/javascript"></script>
    <script src="../../../script/jquery.cookie.js" type="text/javascript"></script>
    <script src="../../../script/jquery.treeview.js" type="text/javascript"></script>
    <script type="text/javascript">
		                $(document).ready(function(){

		                // first example
		                $("#navigation1").treeview({
			                persist: "location",
			                collapsed: true,
			                unique: true
		                });

		                $("#navigation2").treeview({
			                persist: "location",
			                collapsed: true,
			                unique: true
		                });

		                });
	                </script>
    <title>View</title>
  </head>
  <body>
    <h1>
      <img src="../../../Images/icons/view.png" alt="view icon" /> View: vProductModelCatalogDescription</h1>
    <h2>Properties</h2>
    <table id="GetViewList">
      <tr>
        <th>Property</th>
        <th>Value</th>
      </tr>
      <tr>
        <td>Name</td>
        <td>vProductModelCatalogDescription</td>
      </tr>
      <tr>
        <td>ID</td>
        <td>1947153982</td>
      </tr>
      <tr>
        <td>Schema</td>
        <td>
          <a href="../../Schemas/Details/Detail_7.html">Production</a>
        </td>
      </tr>
      <tr>
        <td>Owner</td>
        <td>
          <a href="../../Users/Details/Detail_1.html">dbo</a>
        </td>
      </tr>
      <tr>
        <td>Encrypted</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Schema Bound</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>With Check Option</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>ANSI NULLS</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Uses Quoted Identifier</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Has Opaque Metadata</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Published</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Schema Published</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Replicated</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Has Replication Filter</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Has Unchecked Assembly Data</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Date Correlation View</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Uses Database Collation</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Tracked by CDC</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>MS Shipped</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>Modify Date</td>
        <td>8/8/2010 5:23:46 PM</td>
      </tr>
      <tr>
        <td>Create Date</td>
        <td>8/8/2010 5:23:46 PM</td>
      </tr>
    </table>
    <h2>Extended Properties</h2>
    <table>
      <tr>
        <th>Name</th>
        <th>Value</th>
      </tr>
      <tr>
        <td>MS_Description</td>
        <td>Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.</td>
      </tr>
    </table>
    <h2>View Columns</h2>
    <table>
      <tr>
        <th>Column Name</th>
        <th>Datatype</th>
        <th>Nullable</th>
        <th>Is Identity</th>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_1.html">ProductModelID</a>
        </td>
        <td>int</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_2.html">Name</a>
        </td>
        <td>Name</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_3.html">Summary</a>
        </td>
        <td>nvarchar(max)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_4.html">Manufacturer</a>
        </td>
        <td>nvarchar(max)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_5.html">Copyright</a>
        </td>
        <td>nvarchar(30)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_6.html">ProductURL</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_7.html">WarrantyPeriod</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_8.html">WarrantyDescription</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_9.html">NoOfYears</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_10.html">MaintenanceDescription</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_11.html">Wheel</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_12.html">Saddle</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_13.html">Pedal</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_14.html">BikeFrame</a>
        </td>
        <td>nvarchar(max)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_15.html">Crankset</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_16.html">PictureAngle</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_17.html">PictureSize</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_18.html">ProductPhotoID</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_19.html">Material</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_20.html">Color</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_21.html">ProductLine</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_22.html">Style</a>
        </td>
        <td>nvarchar(256)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_23.html">RiderExperience</a>
        </td>
        <td>nvarchar(1024)</td>
        <td>
          <img src="../../../images/icons/true.png" alt="true" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_24.html">rowguid</a>
        </td>
        <td>uniqueidentifier</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
      <tr>
        <td>
          <a href="Columns/Column_1947153982_25.html">ModifiedDate</a>
        </td>
        <td>datetime</td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
        <td>
          <img src="../../../images/icons/false.png" alt="false" class="boolean" />
        </td>
      </tr>
    </table>
    <h2>Indexes</h2>
    <span>No view indexes defined.</span>
    <h2>Object Level Permissions</h2>
    <span>No object level permissions defined.</span>
    <h2>Column Level Permissions</h2>
    <span>No explicit column permissions granted to this object</span>
    <h2>Objects that depend on [vProductModelCatalogDescription]</h2>
    <ul id="navigation1">
      <li>
        <a href="../../Views/Details/Detail_1947153982.html">Production.vProductModelCatalogDescription</a>
      </li>
    </ul>
    <h2>Objects on which [vProductModelCatalogDescription] depends</h2>
    <ul id="navigation2">
      <li>
        <a href="../../Views/Details/Detail_1947153982.html">Production.vProductModelCatalogDescription</a>
        <ul>
          <li>CatalogDescription.value</li>
          <li>
            <a href="../../Tables/Details/Detail_162099618.html">Production.ProductModel</a>
            <ul>
              <li>
                <a href="../../Datatypes/Details/Detail_260.html">dbo.Name</a>
              </li>
              <li>
                <a href="../../XmlSchemaCollections/Details/Detail_65540.html">Production.ManuInstructionsSchemaCollection</a>
              </li>
              <li>
                <a href="../../XmlSchemaCollections/Details/Detail_65539.html">Production.ProductDescriptionSchemaCollection</a>
              </li>
            </ul>
          </li>
        </ul>
      </li>
    </ul>
    <h2>SQL</h2>
    <table>
      <tr>
        <th>Script</th>
      </tr>
      <tr>
        <td>SET ANSI_NULLS ON<br />SET QUOTED_IDENTIFIER ON<br />CREATE VIEW [Production].[vProductModelCatalogDescription] 
AS 
SELECT 
[ProductModelID] 
,[Name] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
declare namespace html="http://www.w3.org/1999/xhtml"; 
(/p1:ProductDescription/p1:Summary/html:p)[1]', 'nvarchar(max)') AS [Summary] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
(/p1:ProductDescription/p1:Manufacturer/p1:Name)[1]', 'nvarchar(max)') AS [Manufacturer] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
(/p1:ProductDescription/p1:Manufacturer/p1:Copyright)[1]', 'nvarchar(30)') AS [Copyright] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
(/p1:ProductDescription/p1:Manufacturer/p1:ProductURL)[1]', 'nvarchar(256)') AS [ProductURL] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
declare namespace wm="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain"; 
(/p1:ProductDescription/p1:Features/wm:Warranty/wm:WarrantyPeriod)[1]', 'nvarchar(256)') AS [WarrantyPeriod] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
declare namespace wm="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain"; 
(/p1:ProductDescription/p1:Features/wm:Warranty/wm:Description)[1]', 'nvarchar(256)') AS [WarrantyDescription] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
declare namespace wm="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain"; 
(/p1:ProductDescription/p1:Features/wm:Maintenance/wm:NoOfYears)[1]', 'nvarchar(256)') AS [NoOfYears] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
declare namespace wm="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain"; 
(/p1:ProductDescription/p1:Features/wm:Maintenance/wm:Description)[1]', 'nvarchar(256)') AS [MaintenanceDescription] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
declare namespace wf="http://www.adventure-works.com/schemas/OtherFeatures"; 
(/p1:ProductDescription/p1:Features/wf:wheel)[1]', 'nvarchar(256)') AS [Wheel] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
declare namespace wf="http://www.adventure-works.com/schemas/OtherFeatures"; 
(/p1:ProductDescription/p1:Features/wf:saddle)[1]', 'nvarchar(256)') AS [Saddle] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
declare namespace wf="http://www.adventure-works.com/schemas/OtherFeatures"; 
(/p1:ProductDescription/p1:Features/wf:pedal)[1]', 'nvarchar(256)') AS [Pedal] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
declare namespace wf="http://www.adventure-works.com/schemas/OtherFeatures"; 
(/p1:ProductDescription/p1:Features/wf:BikeFrame)[1]', 'nvarchar(max)') AS [BikeFrame] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
declare namespace wf="http://www.adventure-works.com/schemas/OtherFeatures"; 
(/p1:ProductDescription/p1:Features/wf:crankset)[1]', 'nvarchar(256)') AS [Crankset] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
(/p1:ProductDescription/p1:Picture/p1:Angle)[1]', 'nvarchar(256)') AS [PictureAngle] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
(/p1:ProductDescription/p1:Picture/p1:Size)[1]', 'nvarchar(256)') AS [PictureSize] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
(/p1:ProductDescription/p1:Picture/p1:ProductPhotoID)[1]', 'nvarchar(256)') AS [ProductPhotoID] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
(/p1:ProductDescription/p1:Specifications/Material)[1]', 'nvarchar(256)') AS [Material] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
(/p1:ProductDescription/p1:Specifications/Color)[1]', 'nvarchar(256)') AS [Color] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
(/p1:ProductDescription/p1:Specifications/ProductLine)[1]', 'nvarchar(256)') AS [ProductLine] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
(/p1:ProductDescription/p1:Specifications/Style)[1]', 'nvarchar(256)') AS [Style] 
,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; 
(/p1:ProductDescription/p1:Specifications/RiderExperience)[1]', 'nvarchar(1024)') AS [RiderExperience] 
,[rowguid] 
,[ModifiedDate]
FROM [Production].[ProductModel] 
WHERE [CatalogDescription] IS NOT NULL;
<br />EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'VIEW',@level1name=N'vProductModelCatalogDescription'<br /></td>
      </tr>
    </table>
    <h4 class="seealso">See also</h4>
    <a href="../General.html">List of Views</a>
  </body>
</html>