udd: also describe tables

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
 }