#12584: Improve Excel Show Column Command to make it consistent with other DBs

tariqrahiman reported 2014-10-20T20:10:51Z · abhishekj(*) last modified 2014-11-07T10:56:43Z

Dev	JennyNishimura
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Excel
Version	15.0

Version: 15.0.9-6

Build #: 40642

Build Date: 2014-Oct-18 05:49:18 PM

Operating Environment: Mac OS X (10.8.5, x86_64) / UTF-8 / en / US / Oracle Corporation 1.7.0_60-b19

Memory: Max=3,819,962,368; Total=1,479,540,736; Free=464,566,720; CPUs=8

Improve Excel Show Column Command to make it consistent with other DBs

1. Current implementation of Show Column command is :

SHOW COLUMNS table_name [database_name schema_name]

2. Now to be consistent with other DBs can we include below format as well:

SHOW COLUMNS database_name.schema_name.table_name

3. Also for Show Tables can we have

SHOW TABLES [database_name.schema_name]

All Comments (4) Change History

JennyNishimura 2014-10-20T23:02:21Z

Added the following syntax for SHOW COLUMNS and SHOW TABLES commands:

SHOW COLUMNS database_name.schema_name.table_name
SHOW COLUMNS schema_name.table_name

SHOW TABLES [database_name.schema_name]

tariqrahiman 2014-10-20T23:34:37Z

Verified in ADS v15.0.9-8

anilkalshetti 2014-10-22T07:11:01Z

Verified in ADS 15.0.9-12

Please refer Screenshots:
a] Verified-Scripts_in_QA.png
b] Verified-Scripts_in_Fluidshell.png

abhishekj(*) 2014-11-07T10:56:43Z

Verified in ADS v15.0.10 and in ADS v16.0.0-dev-16.