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

Question

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.

Sanchit Gupta (Xebia) · Answer

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