Customization > Schema Customizations > Modifying the Size of DB Columns
Modifying the Size of DB Columns
DB column modifications are defined using the ResizedColumns tag. The table below describes the elements in this tag.
Attribute
Possible Values
Required?
Description
ClassName
name attribute
Yes
Windchill class name of the database table that contains the column to be resized.
Example: <ClassName name="wt.doc.WTDocumentMaster">
ColumnList
A list of Column elements
Yes
List of columns to be resized.
Column
Column resizing definition for a single column
Yes
Details for resizing a given column.
ColumnName
Name of a DB column in the class specified in ClassName
Yes
Name of the column to be resized.
Example: <ColumnName>docType</ColumnName>
Size
Positive integer
Must be greater than or equal to existing column size
Must not be greater than 4000
Yes
New size for the DB column.
Multiple large column sizes in a record (object) can result in performance issues in most databases. So, ensure that you are defining optimal sizes for columns.
Was this helpful?