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!!
Cybersecurity
DevOps Cloud
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more
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!!
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
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