#!/bin/sh
# G.Landais (CDS)
# remove computed column ra_icrs , de_icrs
Vsql -I /home/cds/interfaces -SVIZIR -Ucds <<EOF
delete from metaviz.metaqin where catid=2374 and tabid=1 and colid in (12,13) ;
delete from metaviz.metacol where catid=2374 and name in ('_RA.icrs', '_RA.icrs');
delete from metaviz.metacol where catid=2374 and name in ('_RA.icrs', '_DE.icrs');
EOF