SQL Server 2005 and higher allows you to store XML documents and fragments in a database. PowerDesigner supports this feature through new column properties and the XML schema collection object.
Using an XML Data Type in a Table Column
To specify a column for storing XML, you must have already created an XML schema collection:
- Create a standard column and, on the General tab, select XML in the Data type field.
- Click the Microsoft tab, select an XML schema collection and content type.
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:
Scripting name: ContentType
|