Skip to main content
mohammeds7691
Known Participant
Jun 21, 2023 3:30 PM UTC
Question

I want to add multiple columns from different tables to a existing views in Appian Cloud database

I want to add multiple columns from different tables to a existing views in Appian Cloud database.

Can I use CREATE OR REPLACE VIEW for adding multiple columns from different tables to an existing view?

can anyone provide sample script.

3 replies

sanchitg0002
Inspiring
Jun 21, 2023 3:49 PM UTC

This is not something directly related to Appian, but yes, you can use this SQL command to edit an existing view.

stefanhelzle0001
Brainy
Jun 21, 2023 5:26 PM UTC

The Appian database is a MariaDB. You will find plenty tutorials in the internet.

harshitb6843
Brainy
Jun 22, 2023 5:52 AM UTC

I am a fan of how they have implemented record relationships and how easy everything becomes. Consider using it if your view is not too complex. 

docs.appian.com/.../record-type-relationships.html