[DERBY-1666] Show Views and Show Synonyms has confusing column names in results

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.2.1.6
• Component/s: Tools
• Urgency: Normal
• Issue & fix info: Known fix, Newcomer, Repro attached
• Assignee: Unassigned
• Reporter: David Van Couvering
• Created: 10/Aug/06 19:39
• Updated: 09/Jul/09 11:01

Description

When you run SHOW VIEWS and SHOW SYNONYMS, the column names are confusing. They use TABLE_SCHEM and TABLE_NAME instead of VIEW_SCHEM/VIEW_NAME and SYNONYM_SCHEM/SYONYM_NAME

=== Examples ===

ij> show views;
TABLE_SCHEM |TABLE_NAME |REMARKS
------------------------------------------------------------------------
APP |AA_FLIGHTS |

ij> show synonyms;
TABLE_SCHEM |TABLE_NAME |REMARKS
------------------------------------------------------------------------
APP |COLUMNS |
APP |TRIGGERS |