Navigating Databases With Many Tables

[PsychodelEKS]

Since 10.4 we have object browser filter, though it's better than nothing, it still does not help much with navigation due to “like '%xxx%'” behaviour.

Any chance to have ability to permanently hide certain tables from view? May be in right click menu -> move them to separate folder (Tables [hidden]).

I manage bases with over 1200 tables, and majority of them are out of my interest, so navigation is pain. Filter, as is, does not help much, as for `user`, for example, there are 148 variants in my case and filter works as “like '%user%'”, not even “like 'user%'”. I would prefer it to work as “REGEXP 'user'”, so I could input '^user' to find my table.

[peterlaursen]

Thanks for contacting us here. I think you read my comment in our issue tracker (I guess it was your comment here: http://code.google.com/p/sqlyog/issues/detail?id=1119 (?) )

We will l reply, but due to Xmas/New Year/holiday season it could take a week or more.

[shubh]

Hi,

We have added your request to support REGEXP in Object Browser filter here: http://code.google.com/p/sqlyog/issues/detail?id=1895

Further, with current OB Filter, as you type in edit box, first matching table name(word%) will be filled in filter text box. You can type table name unless you get the table you want and press enter, this will show only desired table in Object Browser.

Regards,

Shubhansh

[Author]

Posts