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