By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,430 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Hide Tables from the Query Builder

100+
P: 107
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
Nov 11 '13 #1

✓ answered by 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.

Share this Question
Share on Google+
3 Replies


zmbd
Expert Mod 5K+
P: 5,287
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.
Nov 11 '13 #2

100+
P: 107
Excellent, ZMBD!

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

All the best!

Gunner
Nov 11 '13 #3

NeoPa
Expert Mod 15k+
P: 31,186
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.
Nov 12 '13 #4

Post your reply

Sign in to post your reply or Sign up for a free account.