PHP - Function Table

Syntax

resource odbc_tables ( resource $connection_id [, string $qualifier 
   [, string $owner [, string $name [, string $types ]]]] )

Definition and Usage

It used to get the list of table names stored in a specific data source

Return Values

It returns odbc result identifiers on success or else false on failure

Parameters

Examples

Try out following example

<?php
   $dbh = odbc_connect($dsn, $user_id, $pwd_id);
   $result = odbc_tables($dbh);
   $tables = array();
   
   while (odbc_fetch_row($result)){
      if(odbc_result($result,"TABLE_TYPE")=="TABLE")
      echo" ".odbc_result($result,"TABLE_NAME");
   }
?>