A simple script to get all tables and their schema from an odbc connection

get_odbc_schema.php

<?php

    $connection = odbc_connect("YOURCONNECTION", "", "");
    $result = odbc_tables($connection);

    $tables = array();
    while (odbc_fetch_row($result))
    {
        if(odbc_result($result,"TABLE_TYPE")=="TABLE")
        {
            $table_name = odbc_result($result,"TABLE_NAME");
            echo $table_name . "\n";

            $odbc_feilds = odbc_columns($connection, null, null, $table_name);

            while (odbc_fetch_row($odbc_feilds))
            {
                echo "\t" . odbc_result($odbc_feilds, "COLUMN_NAME") . "\n";
            }
        }
    }
?>