Sören, Here's one way I've used before. To query for a specific table DB.DBA.FUBAR:
select 1 from sys_keys where key_table = 'DB.DBA.FUBAR'; Have fun! Yrjänä Rajeev J Sebastian wrote: > There is a "tables;" isql command for it ... perhaps thats what you want ? > > Regards > Rajeev J Sebastian > > On 10/6/07, Sören Auer <soeren.a...@gmail.com> wrote: > >> 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 >> >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by: Splunk Inc. >> Still grepping through log files to find problems? Stop. >> Now Search log events and configuration files using AJAX and a browser. >> Download your FREE copy of Splunk now >> http://get.splunk.com/ >> _______________________________________________ >> Virtuoso-users mailing list >> Virtuoso-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/virtuoso-users >> >> > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users >
