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.
Discussion posts and replies are publicly visible
This is not something directly related to Appian, but yes, you can use this SQL command to edit an existing view.
The Appian database is a MariaDB. You will find plenty tutorials in the internet.
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