Skip to main content
Completed

Add option to disable column property Identity in tool Copy Columns

Related products:Software Factory

Arjan Sollie
Thinkwise blogger

In the data modeler when add columns you have the option to select a set of columns and copy these columns into the selected table. I use this tool quite often. Unfortunately this copy option also copies the Identity setting from the selected columns. In 99% of the cases that I use this option I do not want this property to be copied.

I sometimes forget that this property will be copied. The result is a table where by accident a column has been marked as Identity column. It would be a of great help if you have the option to disable the Identity property when using this copy function.

The task already has such a checkbox for the property Primary Key.

 

Did this topic help you find an answer to your question?

6 replies

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
Updated idea status NewOpen

Forum|alt.badge.img+17
  • Moderator
  • 761 replies
  • August 12, 2021

Great idea, but why not set the copy identity to a default of false? Like you said in 99% of the cases this is not the wanted result. Should the default not be set to the most used option?


Arjan Sollie
Thinkwise blogger
Forum|alt.badge.img+14
  • Author
  • Thinkwise blogger
  • 85 replies
  • August 12, 2021

Erwin,

That would be a great addition yes. This checkbox should be set to false by default.


Jeroen van den Belt
Administrator
Forum|alt.badge.img+9

In the 2024.2, we expanded the tab and task to copy columns from another table with the option to copy identity-related settings (Identity, Seed, Increment) and setting Mandatory.

This gives you more control over the desired outcome of the new column.

Image


Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
OpenNext release

Jeroen van den Belt
Administrator
Forum|alt.badge.img+9
Next releaseCompleted

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings