I have a database Im trying to reverse engineer. Is it possible to search all tables, and then all fields the values for a particular value?
Im thinking it would have to be a PowerShell script, but no idea where to start. I think it would have to be something like:-
$dbConnection = msql_connect("localhost","SA","myPassword","myDBInstance")foreach ($table in $db_Connection) { foreach ($field in $table) { if $dbConnection.sql "Select count(*) from $table where `$filed` = 'myValue''" > 0 { response-write "Found value in $table.$field } }}