sabyasachid2763

New Participant

Question

Getting all table names from Database in interface

8 replies
11 views

How to get all table names(>1000) in my interface. I have created a Stored procedure to retrieve table names, used it to create expression rule. But in expression rule only getting 1000 tables. Also in interface only 1000 table names are populating. Please help me in retrieving all table names in interface.

Brainy

Have you configured any batching or something that is restricting the result?

Inspiring

could you please check in stored procedure. I think SP is returning only 1000 rows.

sabyasachid2763Author

New Participant

Yes, in expression rule where i am calling the sp i m getting 1000 rows only, but i want all tables from DB to appian, how to do it help me!

Brainy

Which database are you using? In MSSQL we use a view against INFORMATION_SCHEMA.COLUMNS which works perfectly.