Dear Jana da, The fact is who is having code of any layer he/she can do anything as mentioned by you, deleting columns if he/she logged in with the code of that specific layer on which the columns are created. One more thing Jana da, we are really missing you. Regards, Santosh Kumar Sharma
somnath jana <[EMAIL PROTECTED]> wrote: In axapta it is recomended do not delete field(s) from systables it may cresh the database Thanks and Regards, Somnath Jana Microsoft Certified Axapta Consultant. ----- Original Message ---- From: padmaja_wipro <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Thursday, 21 February, 2008 3:14:18 AM Subject: [Axapta-Knowledge-Village] Best way to delete DEL_ fields? Hi, I would like to delete the fields that were obsolete during upgradation. I have to delete one field that starts with DEL_ from a table. Please note that this field is at sys layer in the table.. So to delete that, do I need to delete from SQLDictonary table which is a system table? Did anyone have tried to delete DEL fields?. if so, what the best way to do this? Thanks in advance. Padma Meet people who discuss and share your passions.. Go to http://in.promos.yahoo.com/groups [Non-text portions of this message have been removed] --------------------------------- Meet people who discuss and share your passions. Join them now. [Non-text portions of this message have been removed]