Skip to main content

managed_database_schemas

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

Overview

Namemanaged_database_schemas
TypeResource
Idazure.sql.managed_database_schemas

Fields

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

NameAccessible byRequired ParamsDescription
getSELECTdatabaseName, managedInstanceName, resourceGroupName, schemaName, subscriptionIdGet managed database schema
list_by_databaseSELECTdatabaseName, managedInstanceName, resourceGroupName, subscriptionIdList managed database schemas

SELECT examples

List managed database schemas

SELECT

FROM azure.sql.managed_database_schemas
WHERE databaseName = '{{ databaseName }}'
AND managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';