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

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_name
from information_schema.tables
where 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

Thank you so much Venkat, So if i am using Query Database smart service and put the SQL query then where can I find the result

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..

https://docs.appian.com/suite/help/24.2/Query_Database_Smart_Service.html#data-tab