Do you have a table ddl statement when creating iq unique syntax, how to remove?

[Former Member]

PowerDesigner > reverse engineering > sybase iq

Do you have a table ddl statement when creating iq unique syntax, how to remove?

[c_baker]

To remove the 'IQ Unique' values on the DDL in each column, just do the following:

1. In any 'Columns' tab (Model/Columns or Table properties), add the 'ExtIQUnicity' attribute to the list of column attributes shown in the dialog tab.
2. Select all rows in the tab and in one ExtIQUnicity cell, delete the contents.  The action will be performed on all rows in the displayed dialog.
3. Apply/Save the changes.
4. The DDL will now be altered to not include the 'IQ Unique' values.

You can also filter/sort on the metadata attribute in the headings, then select attributes to change individually or en-masse.  This is very powerful ability of PowerDesigner and allows you to make huge metadata changes (e.g. datatype) to a model without scripting.

Chris