distal-attribute
distal-attribute
distal-attribute
distal-attribute

Filtering Table Names without Numbers

janday posted 2 weeks ago in General

Hi everyone,

I am new to this forum, and I think it's a great community for a great tool.

Intros aside, I am really curious if it's possible to filter out table names without numbers. I have a huge database with a multi-tenant design, and a lot of these tables have numbers in them (table44123 for example) and some tables don't have numbers (global tables). With this, I would like to list down which tables are not multi-tenant (doesn't have numbers in them)

Thanks,

Jan

kalvaro posted 2 weeks ago

The filter box expects good old regular expressions, so you can start with [^0-9] and fine-tune to your needs.

janday posted 2 weeks ago

The filter box expects good old regular expressions, so you can start with [^0-9] and fine-tune to your needs.

Does the regex work on this filter? The one for viewing the tables of the database? Tried what you've added and I can't seem to get it to work.

1 attachment(s):
  • filter
ansgar posted 2 weeks ago

No, regular expressions are supported on the upper left table filter, but not on the right panel.

janday posted 1 week ago

I see. And no plans to have this in the future?

ansgar posted 1 week ago

Well, with such nice screenshots, you could make a feature request in the tracker?

janday posted 3 days ago

Will do! Thanks :)

Please login to leave a reply, or register at first.