I need to look through an entire database, 210 tables for a unique ID that is a number.
I have limited access to my database through things called nodes (Visual programming.)
These nodes allow for simple querys like SELECT x FROM x WHERE x I believe I can use most commands here.
I'm unfamilar with sql and thought I might be able to get some help here.
Below you can see an example of a node where I can type in commands.
and below that my database structure.
What i'm looking to do is look through the entire database for a unique number, this number changes dynamically but can always be found in the "Id" column of every table. This column is also a Primary Key.
By searching through the database and finding this dynamic unique number in one of the 210 tables I then need to be able to get the table name that the data is located in and the row information ie; all the different column entries for that row.