Good day! Such a hat is a database with a cloud of tables. It is necessary to find a table that contains the paths to the photos of users - can this be done somehow? Manually shoveling is not an option. Server ms sql server 2005 .

  • Once there is a subd means someone uses it. use the interface (web site / program) to pull the functionality you are interested in + hook some monitor sql queries or turn on logging queries on the interface side or subd - jmu

1 answer 1

If you know the name of any column in the table, then there is no problem:

 select table_name from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME='photo'
  • I do not know. There are no other options? - woland
  • one
    Why not. Search by content, if, of course, you know it. Write a dynamic query with a double loop - the first one goes through the tables, and the second one - the columns in the table. - msi
  • Maybe just look at all the tables that are associated with the user table? :) If the database is normally built, then the tables should be connected according to the idea. - null
  • DB is built anyhow (it’s not clear - woland