Page History
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").
Anchor | ||||
---|---|---|---|---|
|
Table of Contents | ||
---|---|---|
|
SHOW DATABASES
SHOW DATABASES
List all available databases.
Example
Code Block |
---|
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
Code Block |
---|
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
Code Block |
---|
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
Code Block |
---|
SHOW COLUMNS Sheet1
GO
SHOW COLUMNS Sheet1 ExcelFolder ExcelFile
GO
SHOW COLUMNS ExcelFolder.ExcelFile.Sheet1
GO
SHOW COLUMNS ExcelFile.Sheet1
GO |