Changing HRDB Table


  • Dear Team,

    Testing purpose we have created SQLMA with Test Table. Now we would like to change it to production SQL view.

    How to change and does it affect SQLMA?



    Tuesday, July 3, 2018 6:06 AM


  • Hi,

    you can simply change the Name of the table in the SQLMA if the main attributes are similar to the testing one.

    Then do a Schema Refresh from the action menu.

    But you can also create a new MA, join the current objects and remove the testing MA later on.


    Peter Stapf - ExpertCircle GmbH - My blog:

    • Proposed as answer by Peter_Stapf Sunday, July 15, 2018 9:14 AM
    • Marked as answer by Shashidhar J Monday, July 16, 2018 9:05 AM
    Tuesday, July 3, 2018 9:51 AM