Skip to main content
S
sabyasachid2763
August 29, 2022
Question

Getting all table names from Database in interface

  • August 29, 2022
  • 8 replies
  • 1 view

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.   

    8 replies

    harshitb6843
    harshitb6843
    August 29, 2022

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

    D
    deepakg681722
    August 29, 2022

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

    S
    sabyasachid2763Author
    August 29, 2022

    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!

    csteward
    csteward
    August 30, 2022

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

    Terms & ConditionsAccessibility statement