Toad World® Forums

900 + tables in a schema

i have over 900 tables in one schema and I am having a heck of a time finding the table name. Mostly because everything is spelled almost the exact same. Can you create some type of search box that I can type my table name in and nav will brign me to the table in the table navigator bar?

Sure would help. I inherited a crazy database from someone and finding stuff is a real pain.

Hi Henry,

Do you think the quick filter in DB Explorer would help? You can type in full name or part of the name there and after you press enter whatever matches the input will appear in the tree below:

quick-filter.jpeg

Thanks,

Vincent