Hi Somnath, You canot delete the system fields ( from AOT ) . You can only update the field properties so that it gets pulled to BUS/CUS/USR layer. Even if you delete from SQLdictionary or Database, when you resync the AOT-Tables, Axapta will recreate/update the table schema and push into SQL....So it does not matter I guess unless you have some secrets.
--- In Axapta-Knowledge-Village@yahoogroups.com, 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] >