xml-schema-collection

Sql existence check for Xml Schema Collection?

Hey all, writing scripts for Sql Server 2005. I am registering a schema with CREATE XML SCHEMA COLLECTION [dbo].[MySchema] AS N'<xsd:schema ... >' Now, as I make changes, I would like to drop it, say with a call to DROP XML SCHEMA COLLECTION [dbo].[MySchema] I run this stuff fairly frequently as I am developing, like DROP ... CRE...

Modifying SQL Server Schema Collection

SQL Server XML Schema Collection is an interesting concept and I find it very useful when designing dynamic data content. However as I work my way through implementing Schema Collections, I find it very difficult to maintain them. Schema Collection DDL allows only CREATE and ALTER/ADD nodes to existing schemes. CREATE XML SCHEMA COLLE...