File: DropTables

package info (click to toggle)
ctn 3.2.0~dfsg-8
  • links: PTS, VCS
  • area: main
  • in suites: sid, trixie
  • size: 16,924 kB
  • sloc: ansic: 179,652; makefile: 7,006; java: 1,863; csh: 1,067; yacc: 523; sh: 424; cpp: 394; sql: 389; lex: 170
file content (16 lines) | stat: -rw-r--r-- 264 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
#!/bin/bash
#
# DropTables
#
if [ -z $1 -o -z $2 ]; then
  echo " "
  echo Usage: "$0 <DIM|Control|TBLTest|FIS> <Database Name>"
  echo " "
  exit
fi

mysql -uctn -pctn $2 < Drop${1}Tables.script
if [ $? != 0 ]; then
  echo Could not drop database: $1
  exit 1
fi