my @col_names = keys %{$sth->fetchrow_hashref};

##</code><code>##

my @col_names = @{$sth->{NAME}};

##</code><code>##

my @col_types = @{$sth->{TYPE}};