syntaxhelp.com Your online cheat sheet!

Altering an XML Schema Collection

-- The first example creates an XML Schema Collection
-- The next example alters the XML Schema Collection

-- Create
CREATE XML SCHEMA COLLECTION OrderInfo AS '

  
    
      
        
      
    
  
'

/*
Validates:
123
*/

-- Alter
ALTER XML SCHEMA COLLECTION OrderInfo ADD '

  
    
      
        
      
    
  
'

/*
Validates 
123

And

	Cash

*/