Skip to main content
sabat0002
Known Participant
June 7, 2022
Question

Database

How to update the existing view(created using joins and tables)  with new column and change the existing column i.e "ID" field (which is having foreign key constraint ) in the cloud database

    5 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 7, 2022

    There is no difference to any other Mysql/Maria DB. Do you have any specific question regarding Appian?

    sabat0002Author
    Known Participant
    June 7, 2022

    do I need to run the sql statements direclty in SQL of cloud database or do I need to download DDL scripts and then update CDT's

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 7, 2022

    I recommend to create a SQL script which you can re-run at any time which drops and creates the view. You do this in DB.

    After the update, you will have to update the CDTs to match the view.

    I am not sure why you would download DDL scripts.

    Terms & ConditionsAccessibility statement