database_columns

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

Overview

Name	database_columns
Type	Resource
Id	azure.sql.database_columns

Fields

vw_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
memory_optimized	text	field from the properties object
resourceGroupName	text	field from the properties object
schemaName	text	field from the properties object
serverName	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

database_columns

Name	Datatype	Description
properties	object	Database column properties.

Methods

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

SELECT examples

List database columns

vw_database_columns

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

database_columns

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