I need to make a query with the name of the table that is in a variable. But is it possible ?.
I tried, but it does not work.
I attached a .png file with the description.
Thanks in advanced
Angélica
I need to make a query with the name of the table that is in a variable. But is it possible ?.
I tried, but it does not work.
I attached a .png file with the description.
Hi Angelica! Really sorry, but prepared statements with dynamic table names aren’t supported in prepared statements. https://docs.retool.com/docs/sql-queries#section-security
We support turning off prepared statements though, which will let you have dynamic table names!