Details
-
Improvement
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
10.2.1.6
-
None
-
None
-
Normal
-
Known fix, Newcomer, Repro attached
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 |