Hide Tables from the Query Builder

[dgunner71]

Is there a way to hide certain tables from the Query Builder?

My client would like to have a means to create queries and I'd like to use the Query Builder for simplicity's sake however, there are certain tables that I would like to prevent them from adding.

I figured this is a long shot, but thought I'd ask.

Thanks for any help.

Gunner

[zmbd]

add "usys" to the table name this makes the table act like a system table.

For example I typically use: usys_tbl_conversionfactors_sae_metric

This hides the table in both the navigation panel and from the query builder and helps to prevent people from accidently changing a conversion factor/formula.

Now the savy user will notice when you use this table in a query and that may compromise this simple method.

[dgunner71]

Excellent, ZMBD!

This is a terrific tip that I was never aware of.

All the best!

Gunner

[NeoPa]

This is a terrific tip that I was never aware of.

I echo that. Great that it now shows up whenever people search for it. Good question.