Skip to main content

vw_databases

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

Overview​

Namevw_databases
TypeView
Idazure.sql.vw_databases

Fields​

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

SQL Definition​

SELECT
location as location,
tags as tags,
sku as sku,
kind as kind,
managedBy as managed_by,
identity as identity,
JSON_EXTRACT(properties, '$.createMode') as "create_mode",
JSON_EXTRACT(properties, '$.collation') as "collation",
JSON_EXTRACT(properties, '$.maxSizeBytes') as "max_size_bytes",
JSON_EXTRACT(properties, '$.sampleName') as "sample_name",
JSON_EXTRACT(properties, '$.elasticPoolId') as "elastic_pool_id",
JSON_EXTRACT(properties, '$.sourceDatabaseId') as "source_database_id",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.databaseId') as "database_id",
JSON_EXTRACT(properties, '$.creationDate') as "creation_date",
JSON_EXTRACT(properties, '$.currentServiceObjectiveName') as "current_service_objective_name",
JSON_EXTRACT(properties, '$.requestedServiceObjectiveName') as "requested_service_objective_name",
JSON_EXTRACT(properties, '$.defaultSecondaryLocation') as "default_secondary_location",
JSON_EXTRACT(properties, '$.failoverGroupId') as "failover_group_id",
JSON_EXTRACT(properties, '$.restorePointInTime') as "restore_point_in_time",
JSON_EXTRACT(properties, '$.sourceDatabaseDeletionDate') as "source_database_deletion_date",
JSON_EXTRACT(properties, '$.recoveryServicesRecoveryPointId') as "recovery_services_recovery_point_id",
JSON_EXTRACT(properties, '$.longTermRetentionBackupResourceId') as "long_term_retention_backup_resource_id",
JSON_EXTRACT(properties, '$.recoverableDatabaseId') as "recoverable_database_id",
JSON_EXTRACT(properties, '$.restorableDroppedDatabaseId') as "restorable_dropped_database_id",
JSON_EXTRACT(properties, '$.catalogCollation') as "catalog_collation",
JSON_EXTRACT(properties, '$.zoneRedundant') as "zone_redundant",
JSON_EXTRACT(properties, '$.licenseType') as "license_type",
JSON_EXTRACT(properties, '$.maxLogSizeBytes') as "max_log_size_bytes",
JSON_EXTRACT(properties, '$.earliestRestoreDate') as "earliest_restore_date",
JSON_EXTRACT(properties, '$.readScale') as "read_scale",
JSON_EXTRACT(properties, '$.highAvailabilityReplicaCount') as "high_availability_replica_count",
JSON_EXTRACT(properties, '$.secondaryType') as "secondary_type",
JSON_EXTRACT(properties, '$.currentSku') as "current_sku",
JSON_EXTRACT(properties, '$.autoPauseDelay') as "auto_pause_delay",
JSON_EXTRACT(properties, '$.currentBackupStorageRedundancy') as "current_backup_storage_redundancy",
JSON_EXTRACT(properties, '$.requestedBackupStorageRedundancy') as "requested_backup_storage_redundancy",
JSON_EXTRACT(properties, '$.minCapacity') as "min_capacity",
JSON_EXTRACT(properties, '$.pausedDate') as "paused_date",
JSON_EXTRACT(properties, '$.resumedDate') as "resumed_date",
JSON_EXTRACT(properties, '$.maintenanceConfigurationId') as "maintenance_configuration_id",
JSON_EXTRACT(properties, '$.isLedgerOn') as "is_ledger_on",
JSON_EXTRACT(properties, '$.isInfraEncryptionEnabled') as "is_infra_encryption_enabled",
JSON_EXTRACT(properties, '$.federatedClientId') as "federated_client_id",
JSON_EXTRACT(properties, '$.keys') as "keys",
JSON_EXTRACT(properties, '$.encryptionProtector') as "encryption_protector",
JSON_EXTRACT(properties, '$.preferredEnclaveType') as "preferred_enclave_type",
JSON_EXTRACT(properties, '$.useFreeLimit') as "use_free_limit",
JSON_EXTRACT(properties, '$.freeLimitExhaustionBehavior') as "free_limit_exhaustion_behavior",
JSON_EXTRACT(properties, '$.sourceResourceId') as "source_resource_id",
JSON_EXTRACT(properties, '$.manualCutover') as "manual_cutover",
JSON_EXTRACT(properties, '$.performCutover') as "perform_cutover",
JSON_EXTRACT(properties, '$.availabilityZone') as "availability_zone",
JSON_EXTRACT(properties, '$.encryptionProtectorAutoRotation') as "encryption_protector_auto_rotation",
subscriptionId,
resourceGroupName,
serverName,
databaseName
FROM azure.sql.databases
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serverName = 'replace-me';