sync_members_member_schemas

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

Overview

Name	sync_members_member_schemas
Type	Resource
Id	azure.sql.sync_members_member_schemas

Fields

The following fields are returned by SELECT queries:

list

Successfully get a sync member schema.

Name	Datatype	Description
lastUpdateTime	string (date-time)	Last update time of the database schema.
tables	array	List of tables in the database full schema.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	resourceGroupName, serverName, databaseName, syncGroupName, syncMemberName, subscriptionId		Gets a sync member database schema.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
databaseName	string	The name of the database on which the sync group is hosted.
resourceGroupName	string	The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName	string	The name of the server.
subscriptionId	string	The subscription ID that identifies an Azure subscription.
syncGroupName	string	The name of the sync group on which the sync member is hosted.
syncMemberName	string	The name of the sync member.

SELECT examples

list

Gets a sync member database schema.

SELECT
lastUpdateTime,
tables
FROM azure.sql.sync_members_member_schemas
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND serverName = '{{ serverName }}' -- required
AND databaseName = '{{ databaseName }}' -- required
AND syncGroupName = '{{ syncGroupName }}' -- required
AND syncMemberName = '{{ syncMemberName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;