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

The following fields are returned by SELECT queries:

list

Successfully get a sync group hub database 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, subscriptionId		Gets a collection of hub database schemas.

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.

SELECT examples

list

Gets a collection of hub database schemas.

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