Skip to main content

vw_managed_databases

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

Overview​

Namevw_managed_databases
TypeView
Idazure.sql.vw_managed_databases

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.collation') as "collation",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.creationDate') as "creation_date",
JSON_EXTRACT(properties, '$.earliestRestorePoint') as "earliest_restore_point",
JSON_EXTRACT(properties, '$.restorePointInTime') as "restore_point_in_time",
JSON_EXTRACT(properties, '$.defaultSecondaryLocation') as "default_secondary_location",
JSON_EXTRACT(properties, '$.catalogCollation') as "catalog_collation",
JSON_EXTRACT(properties, '$.createMode') as "create_mode",
JSON_EXTRACT(properties, '$.storageContainerUri') as "storage_container_uri",
JSON_EXTRACT(properties, '$.sourceDatabaseId') as "source_database_id",
JSON_EXTRACT(properties, '$.crossSubscriptionSourceDatabaseId') as "cross_subscription_source_database_id",
JSON_EXTRACT(properties, '$.restorableDroppedDatabaseId') as "restorable_dropped_database_id",
JSON_EXTRACT(properties, '$.crossSubscriptionRestorableDroppedDatabaseId') as "cross_subscription_restorable_dropped_database_id",
JSON_EXTRACT(properties, '$.storageContainerIdentity') as "storage_container_identity",
JSON_EXTRACT(properties, '$.storageContainerSasToken') as "storage_container_sas_token",
JSON_EXTRACT(properties, '$.failoverGroupId') as "failover_group_id",
JSON_EXTRACT(properties, '$.recoverableDatabaseId') as "recoverable_database_id",
JSON_EXTRACT(properties, '$.longTermRetentionBackupResourceId') as "long_term_retention_backup_resource_id",
JSON_EXTRACT(properties, '$.autoCompleteRestore') as "auto_complete_restore",
JSON_EXTRACT(properties, '$.lastBackupName') as "last_backup_name",
JSON_EXTRACT(properties, '$.crossSubscriptionTargetManagedInstanceId') as "cross_subscription_target_managed_instance_id",
JSON_EXTRACT(properties, '$.isLedgerOn') as "is_ledger_on",
subscriptionId,
resourceGroupName,
managedInstanceName,
databaseName
FROM azure.sql.managed_databases
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND managedInstanceName = 'replace-me' AND databaseName = 'replace-me';