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

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 …