I'm looking for a way, using SQL, to see if a table exists for any random given name
I've tried creating a simple "Select * from MyRandomTableName" but this doesn't work in Marketing Cloud as i need to map the columns from the table to the DE i'm writing it and i can't be sure of the columnnames.
Is there any way, using SQL or any other way thay can be automated, to check if a table exists? I don't want the actual data, i just want to check if it can execute so i know the table with the given name exists.
for testing reasons i've been using the MC interface. Activties -> SQL queries and i've tried to create a statement that it would accept.