Skip to main content

managed_databases_by_instances

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

Overview

Namemanaged_databases_by_instances
TypeResource
Idazure.sql.managed_databases_by_instances

Fields

NameDatatypeDescription
locationstringResource location.
propertiesobjectThe managed database's properties.
tagsobjectResource tags.

Methods

NameAccessible byRequired ParamsDescription
listSELECTmanagedInstanceName, resourceGroupName, subscriptionIdGets a list of managed databases.

SELECT examples

Gets a list of managed databases.

SELECT
location,
properties,
tags
FROM azure.sql.managed_databases_by_instances
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';