1: SELECT * 
   2: FROM  sys.xml_schema_collections 
   3: WHERE name='NameOfSchema'

VN:F [1.4.0_681]
Rating: 10.0/10 (1 vote cast)
Share :
  • Digg
  • del.icio.us
  • Google
  • description
  • StumbleUpon
  • Technorati
  • TwitThis

Related posts:

  1. SQLXML : How to List Schema Elements and Attributes ...
  2. SQLXML : How to Create an XML Schema ...
  3. SQLXML : How to Alter Existing Column Schema (XSD) ...
  4. Script to Drop/Recreate CHECK Constraints ...
  5. SQLXML : How to List Columns That Have the XML Data Type ...
  6. SQLXML : How to Work With XML Elements (or Nodes) in SQL Server ...