Skip to main content

database_schemas

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

Overview

Namedatabase_schemas
TypeResource
Idazure.sql.database_schemas

Fields

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

Methods

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

SELECT examples

List database schemas

SELECT

FROM azure.sql.database_schemas
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';