Need to retrieve list of table names, number of tables, etc., from cloud database

Question

Is there any built in functions or smart service to retrieve the list of table names, number of tables, number of columns in all table and the list of all columns in a table from Appian Cloud Database?

venkat Avuluri · Accepted Answer

Write a Store procedure that will retrieve all the Tables and it's related data , And call this in Execute store procedure smart service . Or Use Query Database smart service write a SQL Statement that will get your data

David Jimenez Calleja · Answer

With this query you can get that information. 
 
 select table_schema, table_name from information_schema.tables where table_type = 'BASE TABLE' 
 order by table_schema, table_name;

Need to retrieve list of table names, number of tables, etc., from cloud database

Top Replies