Skip to main content
venkatrea696188
Inspiring
Jul 18, 2024 6:41 AM UTC

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

8 replies

venkatrea696188
Inspiring
Jul 18, 2024 6:41 AM UTC

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
Jul 18, 2024 7:55 AM UTC

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
Inspiring
Jul 18, 2024 8:25 AM UTC

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