The following SHOW commands can be used to describe Excel schema information. See the SQL Query Reference for information on Utility Statements and Configuration Functions.
"Database" refers to the directory where the Excel file resides. "Schema" refers to the Excel file. "Tables" are the worksheets in the Excel file.
An object name may be quoted or unquoted. If an object name contains special characters, you must quote it whenever you refer to it. The quote identifiers supported by ExcelSQL are the square brackets ([object name]) and double quotes ("object name").
Contents
SHOW DATABASES
SHOW DATABASES
List all available databases.
Example
SHOW DATABASES
SHOW SCHEMAS
SHOW SCHEMAS [database_name]
List schemas of the indicated database.
If database_name is not specified, this command will list the schemas in the current database.
Example
SHOW SCHEMAS GO SHOW SCHEMAS ExcelFolder GO
SHOW TABLES
SHOW TABLES [database_name schema_name]
SHOW TABLES [database_name.schema_name]
List all of the tables of the indicated database and schema.
If database_name and schema_name are not specified, this command will list the tables in the current database and schema.
Example
SHOW TABLES GO SHOW TABLES ExcelFolder ExcelFile GO SHOW TABLES ExcelFolder.ExcelFile GO
SHOW COLUMNS
SHOW [NO_HEADER_ROW] COLUMNS table_name [database_name schema_name]
SHOW [NO_HEADER_ROW] COLUMNS database_name.schema_name.table_name
SHOW [NO_HEADER_ROW] COLUMNS schema_name.table_name
List all of the columns of the indicated table in the indicated database and schema.
If database_name and schema_name are not specified, this command will list the columns of the table in the current database and schema.
By default, the first row is considered as headers. If there is no header, specify the NO_HEADER_ROW option and Excel's headers will be used as column names.
Example
SHOW COLUMNS Sheet1 GO SHOW COLUMNS Sheet1 ExcelFolder ExcelFile GO SHOW COLUMNS ExcelFolder.ExcelFile.Sheet1 GO SHOW COLUMNS ExcelFile.Sheet1 GO