Forum Index

No notifications


No favorites found
Ask the community Need help to achieve something? - Ask the Community
Join the Conversation > Ask the community > Editing Tables View modes: 
User avatar
KnowledgeKube Staff
KnowledgeKube Staff
keiran.martin - 08/06/2020 08:16:16
RE:Editing Tables


Hi Frank,

Yes, you can edit the name of the column and you can also change the data type.  There are a couple of things to be aware of:

  1. Make sure that the data already contained within the column is compatible with the new data type as this may cause you to lose data.
  2. If making a data type or column name change, you will need to ensure that any data sources within your models have been refreshed to pick up the latest changes, otherwise data will not be saved away correctly.

To amend a table within the data designer simply right click on the table you wish to make changes.  Once you are in the Table, double click on the column you wish to change and then make the necessary changes, once complete you can click Update - this will update the column.

Finally, to save the changes you need to click on Update Table, where you will then need to confirm that you are happy for the changes to be saved.

Hope this has answered your question?







User avatar
Frank - 07/06/2020 17:25:37
Editing Tables

Does anyone know if once you have created a table in data designer, are you then able to edit the name of a column or change the data type?

RSS Feed