summaryrefslogtreecommitdiffstats
path: root/bin
diff options
context:
space:
mode:
Diffstat (limited to 'bin')
-rwxr-xr-xbin/udd-query.sh8
1 files changed, 7 insertions, 1 deletions
diff --git a/bin/udd-query.sh b/bin/udd-query.sh
index 50ac1de8..92de9829 100755
--- a/bin/udd-query.sh
+++ b/bin/udd-query.sh
@@ -27,7 +27,13 @@ list_tables() {
FROM information_schema.tables
ORDER BY table_schema,table_name;"
udd_query
- cat $UDD
+ echo
+ for TABLE in $(cat $UDD | cut -d "|" -f2) ; do
+ SQL_QUERY="SELECT column_name, data_type, character_maximum_length
+ FROM INFORMATION_SCHEMA.COLUMNS where table_name = '$TABLE';"
+ cat $UDD
+ echo
+ done
rm $UDD
}