Delete field in dbdict (v9.80)

Hi All,

How can i delete a field in dbdict system navigator?

i only know it can be deleted in db -> dbdict- >tablename
But i'm not sure if it is risky?

please help me solve that problem as soon as possible. Thanks a lot in advance!!

Parents
  • 0  

    Hi,

    There is a solution but you have to make sure the field is empty.

    It works for normal fields like varchar, boolean, float etc... not tested on CLOB or multi values field

    Do a backup of the table before.

    I recommend to not apply this on production. If the field is already created on prod, just keep it.

    if it is on DEV only, not yet on prod, you can apply this solution to avoid this field to be exported in your next release.

    1- open the table in dbdict

    2- you can use the RAD debuger mode to execute the following commqnd:

    x $du.file.empty=true

    3- select and edit the field you want to delete.

    4- In the popup windows, a new button will magically appear to delete the field.

    5- exit 

    6- save the dbdict

Reply
  • 0  

    Hi,

    There is a solution but you have to make sure the field is empty.

    It works for normal fields like varchar, boolean, float etc... not tested on CLOB or multi values field

    Do a backup of the table before.

    I recommend to not apply this on production. If the field is already created on prod, just keep it.

    if it is on DEV only, not yet on prod, you can apply this solution to avoid this field to be exported in your next release.

    1- open the table in dbdict

    2- you can use the RAD debuger mode to execute the following commqnd:

    x $du.file.empty=true

    3- select and edit the field you want to delete.

    4- In the popup windows, a new button will magically appear to delete the field.

    5- exit 

    6- save the dbdict

Children
No Data