I have a db with about 3000 tables. they are organized and what not but sometimes I have a very hard time finding the table I need. Usually there is a part of the business function in the name of the table.
from what I see.
the identifier on the left side of studio manager under tables consists of a combination of two attributes. the first attribute is the schema object and the second value is the table name.
example. there is a table called sewerinstalldate and it is part of the schema assetmanager so in the left side of studio it shows up as
back to original point.... there are about 3000 tables.... is there a way to query the db table folder in studio so it will search for a table that has the word fire in it's identifier