Skip to main content

sql_pool_table_columns

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

Overview

Namesql_pool_table_columns
TypeResource
Idazure.synapse.sql_pool_table_columns

Fields

NameDatatypeDescription
propertiesobjectSql pool column properties.

Methods

NameAccessible byRequired ParamsDescription
list_by_table_nameSELECTresourceGroupName, schemaName, sqlPoolName, subscriptionId, tableName, workspaceNameGets columns in a given table in a SQL pool.

SELECT examples

Gets columns in a given table in a SQL pool.

SELECT
properties
FROM azure.synapse.sql_pool_table_columns
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND schemaName = '{{ schemaName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND tableName = '{{ tableName }}'
AND workspaceName = '{{ workspaceName }}';