managed_database_columns

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

Overview

Name	managed_database_columns
Type	Resource
Id	azure.sql.managed_database_columns

Fields

vw_managed_database_columns

Name	Datatype	Description
columnName	text	field from the properties object
column_type	text	field from the properties object
databaseName	text	field from the properties object
is_computed	text	field from the properties object
managedInstanceName	text	field from the properties object
memory_optimized	text	field from the properties object
resourceGroupName	text	field from the properties object
schemaName	text	field from the properties object
subscriptionId	text	field from the properties object
tableName	text	field from the properties object
temporal_type	text	field from the properties object

managed_database_columns

Name	Datatype	Description
properties	object	Database column properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	columnName, databaseName, managedInstanceName, resourceGroupName, schemaName, subscriptionId, tableName	Get managed database column
list_by_database	SELECT	databaseName, managedInstanceName, resourceGroupName, subscriptionId	List managed database columns
list_by_table	SELECT	databaseName, managedInstanceName, resourceGroupName, schemaName, subscriptionId, tableName	List managed database columns

SELECT examples

List managed database columns

vw_managed_database_columns

SELECT
columnName,
column_type,
databaseName,
is_computed,
managedInstanceName,
memory_optimized,
resourceGroupName,
schemaName,
subscriptionId,
tableName,
temporal_type
FROM azure.sql.vw_managed_database_columns
WHERE databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_database_columns

SELECT
properties
FROM azure.sql.managed_database_columns
WHERE databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';