Hi all, I spend some time today trying to figure out how I can check if there exists a table with a certain name. For the PHP ODBC module there exists the function odbc_tables(), which works. However, due to the problem of the PHP ODBC module with TOP queries I'm now using the pdo_odbc module, which does not provide a similar function. I found the view DB.INFORMATION_SCHEMA.TABLES - but it does not seem to contain all tables - I see just 10 here. Why are not all tables visible here? I also found the Virtuoso's sql_tables() function in the docs, but get an undefined procedure error here???
Sören