restorable_dropped_managed_databases

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

Overview

Name	restorable_dropped_managed_databases
Type	Resource
Id	azure.sql.restorable_dropped_managed_databases

Fields

vw_restorable_dropped_managed_databases

Name	Datatype	Description
creation_date	text	field from the properties object
database_name	text	field from the properties object
deletion_date	text	field from the properties object
earliest_restore_date	text	field from the properties object
location	text	Resource location.
managedInstanceName	text	field from the properties object
resourceGroupName	text	field from the properties object
restorableDroppedDatabaseId	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.

restorable_dropped_managed_databases

Name	Datatype	Description
location	string	Resource location.
properties	object	The restorable dropped managed database's properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	managedInstanceName, resourceGroupName, restorableDroppedDatabaseId, subscriptionId	Gets a restorable dropped managed database.

SELECT examples

Gets a restorable dropped managed database.

vw_restorable_dropped_managed_databases

SELECT
creation_date,
database_name,
deletion_date,
earliest_restore_date,
location,
managedInstanceName,
resourceGroupName,
restorableDroppedDatabaseId,
subscriptionId,
tags
FROM azure.sql.vw_restorable_dropped_managed_databases
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND restorableDroppedDatabaseId = '{{ restorableDroppedDatabaseId }}'
AND subscriptionId = '{{ subscriptionId }}';

restorable_dropped_managed_databases

SELECT
location,
properties,
tags
FROM azure.sql.restorable_dropped_managed_databases
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND restorableDroppedDatabaseId = '{{ restorableDroppedDatabaseId }}'
AND subscriptionId = '{{ subscriptionId }}';