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").
SHOW DATABASES
SHOW DATABASES
...
| Code Block |
|---|
SHOW COLUMNS Sheet1
GO
SHOW COLUMNS Sheet1 ExcelFolder ExcelFile
GO
SHOW COLUMNS ExcelFolder.ExcelFile.Sheet1
GO
SHOW COLUMNS ExcelFile.Sheet1
GO |
Back to top