syntaxhelp.com Your online cheat sheet!

Retrieving the definition of an XML Schema Collection from SQL Server

-- Create an XML Schema Collection
CREATE XML SCHEMA COLLECTION dbo.OrderInfo AS '

  
    
      
        
      
    
  
'
GO

-- Retrieve the definition of XML Schema Collection
-- from SQL Server
SELECT xml_schema_namespace('dbo','OrderInfo')

/*
output:

  
    
      
        
          
            
          
        
      
    
  

*/