Help for this page

Select Code to Download


  1. or download this
        my $sth = $dbh->prepare("SELECT constraint_name FROM INFORMATION_S
    +CHEMA.CONSTRAINT_COLUMN_USAGE WHERE TABLE_NAME = '$tbl'");
        $sth->execute;
    ...
            next unless ($rel =~ /ID/);
            $dbh_tmp->do("ALTER TABLE $tbl DROP CONSTRAINT $rel");
        }
    
  2. or download this
    my $temp = $dbh->selectcol_arrayref($your_sql_statement);