Chapter 15 DBMS-Specific Features

XML table columns

You can create columns with a type of XML and store XML instances in them.

Creating an XML table column

You can create an XML table column in any of the following ways:

  1. Create a column by opening the property sheet of a table, clicking the Columns tab and clicking the Add a Row tool.
  2. Open the property sheet of the new column by clicking the properties tool, and then select XML from the list of Data types on the General tab.
  3. Click the Microsoft tab and specify an XLM schema collection and content type.
  4. Click OK to confirm your changes and close the property sheet.

XML table column properties

You can modify an object's properties from its property sheet. To open an XML table column property sheet, double-click its Browser entry.

The following extended attributes are available on the Microsoft tab:

Name Scripting Name Description
XML schema collection XMLSchemaCollection Specifies an XML schema collection for the type
Content type ContentType Specifies the nature of the content to be stored in the column. You can choose between:

  • CONTENT – [default] the data can contain multiple top-level elements.
  • DOCUMENT – the data can contain only one top-level element.

 

Copyright (C) 2006. Sybase Inc. All rights reserved.