sync_groups_hub_schemas

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

Overview

Name	sync_groups_hub_schemas
Type	Resource
Id	azure.sql.sync_groups_hub_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	Gets a collection of hub database schemas.

SELECT examples

Gets a collection of hub database schemas.

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