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?
Discussion posts and replies are publicly visible
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
With this query you can get that information.
select table_schema, table_namefrom information_schema.tableswhere table_type = 'BASE TABLE'
order by table_schema, table_name;
You got the Query too . Create a process and Use it in Query data base smart service
Thank you so much David, so in the place of information_schema I will be replacing my schema name right?
It's not necessary,, the query will return all the information about the schema... it's a generic query
Sure David, but in query database smart service where can I find the result. I created the PM and in query database smart service i have replaced the sql query with your code. But where can I find the result..