Skip to main content
S
sabat0002
June 7, 2022
Question

Database

  • June 7, 2022
  • 5 replies
  • 0 views

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?

    S
    sabat0002Author
    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