sql_pool_tables
Creates, updates, deletes, gets or lists a sql_pool_tables resource.
Overview
| Name | sql_pool_tables |
| Type | Resource |
| Id | azure.synapse.sql_pool_tables |
Fields
SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.
Methods
| Name | Accessible by | Required Params | Description |
|---|---|---|---|
get | SELECT | resourceGroupName, schemaName, sqlPoolName, subscriptionId, tableName, workspaceName | Get Sql pool table |
list_by_schema | SELECT | resourceGroupName, schemaName, sqlPoolName, subscriptionId, workspaceName | Gets tables of a given schema in a SQL pool. |
SELECT examples
Gets tables of a given schema in a SQL pool.
SELECT
FROM azure.synapse.sql_pool_tables
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND schemaName = '{{ schemaName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';