Use the below functions: odbc_tables(): Get the list of table names stored in a specific data source(http://in2.php.net/manual/en/function.odbc-tables.php) odbc_columns(): Lists the column names in specified tables(http://in2.php.net/manual/en/function.odbc-columns.php)