Search Results

Try and adapt this new version of my script :awk '
BEGIN {
fmtI = "%-12s %-12s %-16s %s\n";
fmtNoI = "%-12s %s\n";

print "TABLES"
printf fmtI, "TABLE_NAME", "COLUMN_NAME",...

Seems thatr there is a missing line in your script : next ; # Proceed next record
}

/^ADD/,/;[[:space:]]*$/ { # Select ADD records (from ADD to

...

Maybe
awk '/^alter table/ {print $3}' file > table.names
:confused: