StrataFrame Forum

Unique Index modification

http://forum.strataframe.net/Topic22601.aspx

By Edhy Rijo - 4/1/2009

I have a table with a unique index, I wanted to remove the "Unique" using the DDT and got the following error:

Modifying the IsUnique property of the Index object is not allowed. You must drop and recreate the object with the desired property.


Does this mean that I would need to connect to the customer's server, modify the table and remove the unique flag? or is there a wait to automate this in the DDT?
By Trent L. Taylor - 4/4/2009

Does this mean that I would need to connect to the customer's server, modify the table and remove the unique flag? or is there a wait to automate this in the DDT?

Well, it depends .  One way to automate this regardless of the current deployment state is to use the Pre-Deployment scripts to remove this flag.

By Edhy Rijo - 4/4/2009

Thanks Trent, will try that out.