Contents tagged with Drop Table

  • Closest possible to database approach in Acumatica

    Hello everybody,

    today I want to leave another post about internals of Acumatica, about which you may heard something like "Never try it at home". In another words, sometime you may need to do the following in Acumaitca:

    Insert directly into database ( for this purpose I'd recommend you to use PXDatabase.Insert )

    Alter Table

    Alter Schema of Table

    Create column

    Drop column

    Drop Table

    .... this list is not exhaustive

    and any other system level activities. By default and for SOLId SOLID SOLID reasons you can't achieve it. But sometime you may need it. 

    Below goes sample of code, which you can use for setting identity insert to on, and then execute some update onf the table, and … more