.show external table command
Returns a specified external table or all external tables in the database.
This command is relevant to any external table of any type. For an overview of external tables, see external tables.
Permissions
You must have at least Database User, Database Viewer, Database Monitor to run these commands. For more information, see role-based access control.
Syntax
.show
external
tables
.show
external
table
TableName
Learn more about syntax conventions.
Parameters
Name | Type | Required | Description |
---|---|---|---|
TableName | string |
✔️ | The name of the external table to show. |
Returns
Output parameter | Type | Description |
---|---|---|
TableName | string |
Name of external table |
TableType | string |
Type of external table |
Folder | string |
Table's folder |
DocString | string |
String documenting the table |
Properties | string |
Table's JSON serialized properties (specific to the type of table) |
Example
.show external tables
.show external table T
TableName | TableType | Folder | DocString | Properties |
---|---|---|---|---|
T | Blob | ExternalTables | Docs | {} |
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om