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!!

  • 0  

    I think this will be OK with some caveats

    It may be easier just to remove the field from forms and ignore the dbdict entry (particularly OOTB fields)

    Check if the field has any data posted or used by other processes/files in SM, if so I would just hide the field if you don't want it to be seen

    Take a full database backup first

    If you do this make sure the corresponding database entry/field has been cleared and removed also so the SM dbdict and DB match

    Fully test this in a development system before doing it in production

  • 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