Solved

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

Forum|Forum|2 years ago
July 18, 2024
8 replies
0 views

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?

Best answer by venkatrea696188

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

venkatrea696188Answer

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

davidj137213

Brainy

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;

venkatrea696188

You got the Query too . Create a process and Use it in Query data base smart service

Sign up

Login with SSO

Login to the community

Login with SSO