XML Management
Some of the databases supported by DatabaseSpy provide XML data types and other XML-related features. In DatabaseSpy, support for the XML-related features across various database kinds can be summarized as follows:
Feature | Description | Database support |
|---|---|---|
Editing of XML columns | If a database column is of type XML, you can load XML instance files into the database fields, or save the content of XML database fields to local files, see Editing XML Columns | •DB2 9.1 and later •Oracle •PostgreSQL 8.3 and later •SQL Server |
XML Schema management | You can register or drop database XML schemas through a dedicated dialog box, see Managing XML Schemas | •DB2 9.1 or later •Oracle •SQL Server |
Assign XML schema to a column | •SQL Server | |
Assign XML schema to a data field | •DB2 9.1 and later |