Script Completo - Descobrir Todos os Nomes das Tabelas no Informix

Script Completo - Descobrir Todos os Nomes das Tabelas no Informix

LOG1="/tmp/123456_pode_deletar_1234_1.log"
LOG2="/tmp/123456_pode_deletar_1234_2.log"
LOG3="/tmp/123456_pode_deletar_1234_3.log"
LOG4="/tmp/123456_pode_deletar_1234_4.log"
LOG5="/tmp/123456_pode_deletar_1234_5.log"
LOG6="/tmp/123456_pode_deletar_1234_6.log"
LOG7="/tmp/123456_pode_deletar_1234_7.log"
LOG8="/tmp/123456_pode_deletar_1234_8.log"


clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo
echo
echo -n " Digite o Nome do BANCO DE DADOS .: "
read BANCO_DE_DADOS
echo

clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo
echo
echo "                    +---------------------------------------------------------+"
echo "                    |                                                         |"
echo "                    |                aguarde alguns segundos ...              |"
echo "                    |                                                         |"
echo "                    +---------------------------------------------------------+"
echo

dbschema -d $BANCO_DE_DADOS -t all | grep "create table" > $LOG1

clear
echo "-------------------------------------------------------------------------------------------------"
echo -n
echo -n "$(date "+%d/%m/%Y")"
echo -n "      "
echo -n "                ***** INFORMIX BASIC SERVICES *****   "
echo -n "                   "
echo "$(date "+%T")"
echo "-------------------------------------------------------------------------------------------------"
echo
echo

sed 's/create table//' $LOG1

rm $LOG1;


echo