the-xsd-redefine-element.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
The <xsd:redefine> Element	Learn about support for the W3C XSD redefine element and how to update an XML schema or its components.	MikeRayMSFT	mikeray	randolphwest	05/05/2022	sql	xml	conceptual	xsd:redefine element

The <xsd:redefine> element

[!INCLUDE SQL Server Azure SQL Database]

The W3C XSD redefine element provides support for redefining schema components. However, support for this directive is potentially costly to performance and also requires that [!INCLUDEssNoVersion] revalidate all instances of the xml data type associated with the redefined schema. Therefore, [!INCLUDEssNoVersion] doesn't support this element. XML schemas that include the <xsd:redefine> element are rejected by the server.

To update a schema or its components, you can do the following instead:

1. Create a new XML Schema collection with the modified schema components.

2. Retype all xml data types (XML DT) that use the XML Schema collection to be redefined to use the new XML Schema collection instead. To do this, use the ALTER COLUMN option of the ALTER TABLE command for retyping columns, or change the XML Schema collection constraints on variables or parameters.

3. Drop the old version of the XML Schema collection.

See also

• Requirements and Limitations for XML Schema Collections on the Server