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

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

Methods

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

SELECT examples

Gets a sync member database schema.

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