Skip to main content

sql_pool_schemas

Creates, updates, deletes, gets or lists a sql_pool_schemas resource.

Overview

Namesql_pool_schemas
TypeResource
Idazure.synapse.sql_pool_schemas

Fields

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

NameAccessible byRequired ParamsDescription
getSELECTresourceGroupName, schemaName, sqlPoolName, subscriptionId, workspaceNameGet Sql Pool schema
listSELECTresourceGroupName, sqlPoolName, subscriptionId, workspaceNameGets schemas of a given SQL pool.

SELECT examples

Gets schemas of a given SQL pool.

SELECT

FROM azure.synapse.sql_pool_schemas
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';