I was looking for a way to get a tuple where your primary key is equal to the value that I'm passing by parameter, that is:
SELECT * FROM clientes WHERE primary_key = 1;
Or it could be:
SELECT * FROM boletas WHERE primary_key = 'boleta1';
The thing is that I do not know in advance which is the primary key, nor its type, but I know that the parameter to evaluate is going to be correct .
I would also need an SQL statement since the ones I found are from MySQL (eg
SHOW KEYS FROM clientes WHERE Key_name = 'PRIMARY' ) or SQL Server, what I need is something typical of native SQL, which any DBMS can understand, since the system could have to face anyone.
Is it possible to do this?