printsqla($dbType, $sqla2);
        }
    }
    if ($dbType == 'odbc_mssql') {
        $dsn = $dsn = "PROVIDER=MSDASQL;Driver={SQL Server};Server=localhost;Database=northwind;";
        if (@$db->Connect($dsn, "sa", "natsoft", "test")) {
        }
        $dict->SetSchema('');
        $sqla2 = $dict->ChangeTableSQL('adoxyz', $flds);
        if ($sqla2) {
            printsqla($dbType, $sqla2);
        }
    }
    adodb_pr($dict->databaseType);
    printsqla($dbType, $dict->DropColumnSQL('table', array('my col', '`col2_with_Quotes`', 'A_col3', 'col3(10)')));
    printsqla($dbType, $dict->ChangeTableSQL('adoxyz', 'LASTNAME varchar(32)'));
}
function printsqla($dbType, $sqla)
{
    print "<pre>";
    //print_r($dict->MetaTables());
    foreach ($sqla as $s) {
        $s = htmlspecialchars($s);
        print "{$s};\n";
        if ($dbType == 'oci8') {
            print "/\n";
        }
    }
    print "</pre><hr />";
}
/***

    if (file_exists('d:\\inetpub\\wwwroot\\php\\phplens\\adodb\\adodb.inc.php')) {
        if ($dbType == 'mysql') {
            $db->Connect('localhost', "root", "", "test");
            $dict->SetSchema('');
            $sqla2 = $dict->ChangeTableSQL('adoxyz', $flds);
            if ($sqla2) {
                printsqla($dbType, $sqla2);
            }
        }
    }
    if ($dbType == 'postgres') {
        $db->Connect('localhost', "tester", "test", "test");
        $dict->SetSchema('');
        $sqla2 = $dict->ChangeTableSQL('adoxyz', $flds);
        if ($sqla2) {
            printsqla($dbType, $sqla2);
        }
    }
}
function printsqla($dbType, $sqla)
{
    print "<pre>";
    //print_r($dict->MetaTables());
    foreach ($sqla as $s) {
        $s = htmlspecialchars($s);
        print "{$s};\n";
        if ($dbType == 'oci8') {
            print "/\n";
        }
    }
    print "</pre><hr>";