Provide "WITH OVERWRITE" or a similar option for ALTER XML SCHEMA COLLECTION - by Adam Machanic

Status : 


Sign in
to vote
ID 262232 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 3/7/2007 3:48:21 PM
Access Restriction Public


Altering an XML schema collection to make a simple change to the schema is a complete pain.  For example, today a customer wanted to change one of the elements from a 50-character string to a 100-character string. The only semi-good way to handle this is to create a new schema collection, then go through and update every single reference that uses the old collection -- really a lot more work than necessary.  SQL Server should be able to do this for me.
Sign in to post a comment.
Posted by JSG080 on 3/19/2009 at 8:13 AM
Existing SQL Server 2005 functionality is very limited. In my case I'm just trying to add a new optional attribute to a subordinate element node. I can somewhat understand the binding to the XML column, but having to unbind the stored procedure parameters! Come on! These are just references. BTW, if a variable within a stored procedure is bound to the schema, you're OK -- which is totally inconsistent.
Posted by Microsoft on 3/22/2007 at 6:50 PM
Dear Adam. Thanks for your feedback. We will look into providing such functionality in a future release of SQL Server and appreciate your feedback.

Thanks and best regards