| title | The <xsd:redefine> Element | Microsoft Docs | |
|---|---|---|
| description | Learn about support for the W3C XSD redefine element and how to update an XML schema or its components. | |
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql | |
| ms.prod_service | database-engine | |
| ms.reviewer | ||
| ms.technology | xml | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 5f3e9b65-f10e-4db2-a62c-b270ac11d04e | |
| author | MightyPen | |
| ms.author | genemi |
[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md] 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] does not 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:
-
Create a new XML Schema collection with the modified schema components.
-
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.
-
Drop the old version of the XML Schema collection.
Requirements and Limitations for XML Schema Collections on the Server