managed_database_tables

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

Overview

Name	managed_database_tables
Type	Resource
Id	azure.sql.managed_database_tables

Fields

vw_managed_database_tables

Name	Datatype	Description
databaseName	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_tables

Name	Datatype	Description
properties	object	Database table properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, managedInstanceName, resourceGroupName, schemaName, subscriptionId, tableName	Get managed database table
list_by_schema	SELECT	databaseName, managedInstanceName, resourceGroupName, schemaName, subscriptionId	List managed database tables

SELECT examples

List managed database tables

vw_managed_database_tables

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

managed_database_tables

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