Access to a large number of tables in sql

Stephen Kirk
Stephen Kirk Active Partner
10 Comments Second Anniversary Level 200: Building A Planning Solution in Board Level 100: Foundations of Building in Board
in Platform

I'm having an issue with a large sql database connected with BOARD that when the user scrolls through the tables available, it doesn't show all of the tables - it cuts off. Showing this:

 

Scrolled all the way down:

image

 

I cannot access tables past PUB.RM (sorted alphabetically)

 

However, if I use the filter:

image

I find more tables that are further down alphabetically.

 

Is there any way to be able to see all tables in a sql connection without beforehand knowing what they may be called?

 

Thanks,

Stephen

Tagged:

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    Hi Stephen Kirk!

     

    As far as I know, there is no other way, since the search function implemented here will only search the displayed tables. So the workaround would be to look up the tables in your SQL database directly beforehand (where you sometimes can't search either) or you might be lucky to find a table in your sql database containing the metadata and you could search this beforehand--but since you might not know the name of the desired table this may prove difficult as well.

     

    Kind Regards,

    Helmut

  • Unknown
    Unknown Active Partner

    One workaround is to update the login permissions of the SQL user. By selecting only the appropriate tables to which BOARD needs access, all the others will be hidden. 

  • Paul Wyatt
    Paul Wyatt Customer
    100 Comments 100 Up Votes 100 Likes Second Anniversary

    Thanks Helmut Heimann & Bob Gill.  I had no idea of these limitations but am very pleased to have learnt about them from the question raised by Stephen Kirk.  Whilst I love to learn how to model with BOARD, I think it is equally important to understand limitations and what to do when thinks go wrong within a system.

Categories