how to find a value in a database that contains many tables without knowing its column name?

Question

i want to find tables and column names that their cell values are equal to 20.34 in a database.

Answer 1

That would be hard to do, if not impossible, if you have full access of the database and server, you can try to investigate which tables contain floating point type fields and make note of the table & field names (this isn't an easy task FYI). Then, having that information at hand, you can go try select records from the tables whose names you noted.

BTW I have never encountered such a case, can you elaborate on what it is you are doing?