Remove Schema from Schema Collection

is possible remove single schema schema collection?

as far know can delete collection or add schema.

//creating schema collection
create xml schema collection templatecollection as
n'<xschema>...</xschema>'

//adding schema
alter xml schema collection templatecollection add
n'<xschema>...</xschema>'


//deleting schema collection
if exists (select * sys.xml_schema_collections c, sys.schemas s c.schema_id = s.schema_id , (quotename(s.name) + '.' + quotename(c.name)) = n'[dbo].[catalogcollection]')
drop xml schema collection [dbo].[templatecollection ]

i haven't found solution. help!!!

danke,
anna

anna,

 

in sql server 2005, not support deletion schema evolution option. please send feedback https://connect.microsoft.com/sqlserver. workaround, can create new schema contains namespaces need , execute alter table ... alter column ddls on xml columns , change type new schema collection.

 

regards,

galex yen

SQL Server  >  SQL Server XML