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

Steps To create an XML table column:

  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 Description
XML schema collection Specifies an XML schema collection for the type.

Scripting name: XMLSchemaCollection
Content type 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.


Scripting name: ContentType

 

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