Search for strings in entire Database

  • I found many scripts to list table names & field names of a database.

    Now, I am in looking for a way to search for strings in tables and fields in a database. I found a bunch of scripts to search for strings in a database. One ran too slow. Another returned too many errors.

    Sorry If this question has been asked before but which script should I use to search for strings, returning the location of fields and tables while performs super fast?

  • You're looking for strings in any column in any table? Sounds like the design of your database is seriously dodgy.

  • I am looking for a function where I can enter a string and it will return the location of that string (the table and the field).  This function can be used against any database.

    It is basically a text search function, similar to in Excel, when you do a search for a string, it list the sheet and cell locations.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply