Link to resource definition: Microsoft.Sql/servers/databases
| Default Path | Alias |
|---|---|
managedBy | Microsoft.Sql/servers/databases/managedBy |
properties.autoPauseDelay | Microsoft.Sql/servers/databases/autoPauseDelay |
properties.availabilityZone | Microsoft.Sql/servers/databases/availabilityZone |
properties.catalogCollation | Microsoft.Sql/servers/databases/catalogCollation |
properties.collation | Microsoft.Sql/servers/databases/collation |
properties.containmentState | Microsoft.Sql/servers/databases/containmentState |
properties.createMode | Microsoft.Sql/servers/databases/createMode |
properties.creationDate | Microsoft.Sql/servers/databases/creationDate |
properties.currentBackupStorageRedundancy | Microsoft.Sql/servers/databases/currentBackupStorageRedundancy |
properties.currentServiceObjectiveId | Microsoft.Sql/servers/databases/currentServiceObjectiveId |
properties.currentServiceObjectiveName | Microsoft.Sql/servers/databases/currentServiceObjectiveName |
properties.currentSku | Microsoft.Sql/servers/databases/currentSku |
properties.currentSku.capacity | Microsoft.Sql/servers/databases/currentSku.capacity |
properties.currentSku.family | Microsoft.Sql/servers/databases/currentSku.family |
properties.currentSku.name | Microsoft.Sql/servers/databases/currentSku.name |
properties.currentSku.size | Microsoft.Sql/servers/databases/currentSku.size |
properties.currentSku.tier | Microsoft.Sql/servers/databases/currentSku.tier |
properties.databaseId | Microsoft.Sql/servers/databases/databaseId |
properties.defaultSecondaryLocation | Microsoft.Sql/servers/databases/defaultSecondaryLocation |
properties.earliestRestoreDate | Microsoft.Sql/servers/databases/earliestRestoreDate |
properties.elasticPoolId | Microsoft.Sql/servers/databases/elasticPoolId |
properties.elasticPoolName | Microsoft.Sql/servers/databases/elasticPoolName |
properties.encryptionProtector | Microsoft.Sql/servers/databases/encryptionProtector |
properties.encryptionProtectorAutoRotation | Microsoft.Sql/servers/databases/encryptionProtectorAutoRotation |
properties.failoverGroupId | Microsoft.Sql/servers/databases/failoverGroupId |
properties.federatedClientId | Microsoft.Sql/servers/databases/federatedClientId |
properties.freeLimitExhaustionBehavior | Microsoft.Sql/servers/databases/freeLimitExhaustionBehavior |
properties.highAvailabilityReplicaCount | Microsoft.Sql/servers/databases/highAvailabilityReplicaCount |
properties.isInfraEncryptionEnabled | Microsoft.Sql/servers/databases/isInfraEncryptionEnabled |
properties.isLedgerOn | Microsoft.Sql/servers/databases/isLedgerOn |
properties.keys | Microsoft.Sql/servers/databases/keys |
properties.licenseType | Microsoft.Sql/servers/databases/licenseType |
properties.longTermRetentionBackupResourceId | Microsoft.Sql/servers/databases/longTermRetentionBackupResourceId |
properties.maintenanceConfigurationId | Microsoft.Sql/servers/databases/maintenanceConfigurationId |
properties.manualCutover | Microsoft.Sql/servers/databases/manualCutover |
properties.maxLogSizeBytes | Microsoft.Sql/servers/databases/maxLogSizeBytes |
properties.maxSizeBytes | Microsoft.Sql/servers/databases/maxSizeBytes |
properties.minCapacity | Microsoft.Sql/servers/databases/minCapacity |
properties.pausedDate | Microsoft.Sql/servers/databases/pausedDate |
properties.performCutover | Microsoft.Sql/servers/databases/performCutover |
properties.preferredEnclaveType | Microsoft.Sql/servers/databases/preferredEnclaveType |
properties.primaryDelegatedIdentityClientId | Microsoft.Sql/servers/databases/primaryDelegatedIdentityClientId |
properties.provisioningState | Microsoft.Sql/servers/databases/provisioningState |
properties.readReplicaCount | Microsoft.Sql/servers/databases/readReplicaCount |
properties.readScale | Microsoft.Sql/servers/databases/readScale |
properties.recommendedIndex | Microsoft.Sql/servers/databases/recommendedIndex |
properties.recommendedIndex[*] | Microsoft.Sql/servers/databases/recommendedIndex[*] |
properties.recommendedIndex[*].id | Microsoft.Sql/servers/databases/recommendedIndex[*].id |
properties.recommendedIndex[*].name | Microsoft.Sql/servers/databases/recommendedIndex[*].name |
properties.recommendedIndex[*].properties.action | Microsoft.Sql/servers/databases/recommendedIndex[*].action |
properties.recommendedIndex[*].properties.columns | Microsoft.Sql/servers/databases/recommendedIndex[*].columns |
properties.recommendedIndex[*].properties.columns[*] | Microsoft.Sql/servers/databases/recommendedIndex[*].columns[*] |
properties.recommendedIndex[*].properties.created | Microsoft.Sql/servers/databases/recommendedIndex[*].created |
properties.recommendedIndex[*].properties.estimatedImpact | Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact |
properties.recommendedIndex[*].properties.estimatedImpact[*] | Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact[*] |
properties.recommendedIndex[*].properties.estimatedImpact[*].changeValueAbsolute | Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact[*].changeValueAbsolute |
properties.recommendedIndex[*].properties.estimatedImpact[*].changeValueRelative | Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact[*].changeValueRelative |
properties.recommendedIndex[*].properties.estimatedImpact[*].name | Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact[*].name |
properties.recommendedIndex[*].properties.estimatedImpact[*].unit | Microsoft.Sql/servers/databases/recommendedIndex[*].estimatedImpact[*].unit |
properties.recommendedIndex[*].properties.includedColumns | Microsoft.Sql/servers/databases/recommendedIndex[*].includedColumns |
properties.recommendedIndex[*].properties.includedColumns[*] | Microsoft.Sql/servers/databases/recommendedIndex[*].includedColumns[*] |
properties.recommendedIndex[*].properties.indexScript | Microsoft.Sql/servers/databases/recommendedIndex[*].indexScript |
properties.recommendedIndex[*].properties.indexType | Microsoft.Sql/servers/databases/recommendedIndex[*].indexType |
properties.recommendedIndex[*].properties.lastModified | Microsoft.Sql/servers/databases/recommendedIndex[*].lastModified |
properties.recommendedIndex[*].properties.reportedImpact | Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact |
properties.recommendedIndex[*].properties.reportedImpact[*] | Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact[*] |
properties.recommendedIndex[*].properties.reportedImpact[*].changeValueAbsolute | Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact[*].changeValueAbsolute |
properties.recommendedIndex[*].properties.reportedImpact[*].changeValueRelative | Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact[*].changeValueRelative |
properties.recommendedIndex[*].properties.reportedImpact[*].name | Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact[*].name |
properties.recommendedIndex[*].properties.reportedImpact[*].unit | Microsoft.Sql/servers/databases/recommendedIndex[*].reportedImpact[*].unit |
properties.recommendedIndex[*].properties.schema | Microsoft.Sql/servers/databases/recommendedIndex[*].schema |
properties.recommendedIndex[*].properties.state | Microsoft.Sql/servers/databases/recommendedIndex[*].state |
properties.recommendedIndex[*].properties.table | Microsoft.Sql/servers/databases/recommendedIndex[*].table |
properties.recommendedIndex[*].type | Microsoft.Sql/servers/databases/recommendedIndex[*].type |
properties.recoverableDatabaseId | Microsoft.Sql/servers/databases/recoverableDatabaseId |
properties.recoveryServicesRecoveryPointId | Microsoft.Sql/servers/databases/recoveryServicesRecoveryPointId |
properties.recoveryServicesRecoveryPointResourceId | Microsoft.Sql/servers/databases/recoveryServicesRecoveryPointResourceId |
properties.requestedBackupStorageRedundancy | Microsoft.Sql/servers/databases/requestedBackupStorageRedundancy |
properties.requestedBackupStorageRedundancy | Microsoft.Sql/servers/databases/storageAccountType |
properties.requestedServiceObjectiveId | Microsoft.Sql/servers/databases/requestedServiceObjectiveId |
properties.requestedServiceObjectiveName | Microsoft.Sql/servers/databases/requestedServiceObjectiveName.v2 |
properties.restorableDroppedDatabaseId | Microsoft.Sql/servers/databases/restorableDroppedDatabaseId |
properties.restorePointInTime | Microsoft.Sql/servers/databases/restorePointInTime |
properties.resumedDate | Microsoft.Sql/servers/databases/resumedDate |
properties.sampleName | Microsoft.Sql/servers/databases/sampleName |
properties.secondaryType | Microsoft.Sql/servers/databases/secondaryType |
properties.serviceLevelObjective | Microsoft.Sql/servers/databases/serviceLevelObjective |
properties.serviceTierAdvisors | Microsoft.Sql/servers/databases/serviceTierAdvisors |
properties.serviceTierAdvisors[*] | Microsoft.Sql/servers/databases/serviceTierAdvisors[*] |
properties.serviceTierAdvisors[*].id | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].id |
properties.serviceTierAdvisors[*].name | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].name |
properties.serviceTierAdvisors[*].properties.activeTimeRatio | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].activeTimeRatio |
properties.serviceTierAdvisors[*].properties.avgDtu | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].avgDtu |
properties.serviceTierAdvisors[*].properties.confidence | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].confidence |
properties.serviceTierAdvisors[*].properties.currentServiceLevelObjective | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].currentServiceLevelObjective |
properties.serviceTierAdvisors[*].properties.currentServiceLevelObjectiveId | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].currentServiceLevelObjectiveId |
properties.serviceTierAdvisors[*].properties.databaseSizeBasedRecommendationServiceLevelObjective | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].databaseSizeBasedRecommendationServiceLevelObjective |
properties.serviceTierAdvisors[*].properties.databaseSizeBasedRecommendationServiceLevelObjectiveId | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].databaseSizeBasedRecommendationServiceLevelObjectiveId |
properties.serviceTierAdvisors[*].properties.disasterPlanBasedRecommendationServiceLevelObjective | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].disasterPlanBasedRecommendationServiceLevelObjective |
properties.serviceTierAdvisors[*].properties.disasterPlanBasedRecommendationServiceLevelObjectiveId | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].disasterPlanBasedRecommendationServiceLevelObjectiveId |
properties.serviceTierAdvisors[*].properties.maxDtu | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].maxDtu |
properties.serviceTierAdvisors[*].properties.maxSizeInGB | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].maxSizeInGB |
properties.serviceTierAdvisors[*].properties.minDtu | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].minDtu |
properties.serviceTierAdvisors[*].properties.observationPeriodEnd | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].observationPeriodEnd |
properties.serviceTierAdvisors[*].properties.observationPeriodStart | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].observationPeriodStart |
properties.serviceTierAdvisors[*].properties.overallRecommendationServiceLevelObjective | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].overallRecommendationServiceLevelObjective |
properties.serviceTierAdvisors[*].properties.overallRecommendationServiceLevelObjectiveId | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].overallRecommendationServiceLevelObjectiveId |
properties.serviceTierAdvisors[*].properties.serviceLevelObjectiveUsageMetrics | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].serviceLevelObjectiveUsageMetrics |
properties.serviceTierAdvisors[*].properties.serviceLevelObjectiveUsageMetrics[*] | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].serviceLevelObjectiveUsageMetrics[*] |
properties.serviceTierAdvisors[*].properties.serviceLevelObjectiveUsageMetrics[*].inRangeTimeRatio | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].serviceLevelObjectiveUsageMetrics[*].inRangeTimeRatio |
properties.serviceTierAdvisors[*].properties.serviceLevelObjectiveUsageMetrics[*].serviceLevelObjective | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].serviceLevelObjectiveUsageMetrics[*].serviceLevelObjective |
properties.serviceTierAdvisors[*].properties.serviceLevelObjectiveUsageMetrics[*].serviceLevelObjectiveId | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].serviceLevelObjectiveUsageMetrics[*].serviceLevelObjectiveId |
properties.serviceTierAdvisors[*].properties.usageBasedRecommendationServiceLevelObjective | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].usageBasedRecommendationServiceLevelObjective |
properties.serviceTierAdvisors[*].properties.usageBasedRecommendationServiceLevelObjectiveId | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].usageBasedRecommendationServiceLevelObjectiveId |
properties.serviceTierAdvisors[*].type | Microsoft.Sql/servers/databases/serviceTierAdvisors[*].type |
properties.sourceDatabaseDeletionDate | Microsoft.Sql/servers/databases/sourceDatabaseDeletionDate |
properties.sourceDatabaseId | Microsoft.Sql/servers/databases/sourceDatabaseId |
properties.sourceResourceId | Microsoft.Sql/servers/databases/sourceResourceId |
properties.status | Microsoft.Sql/servers/databases/status |
properties.transparentDataEncryption | Microsoft.Sql/servers/databases/transparentDataEncryption |
properties.transparentDataEncryption[*] | Microsoft.Sql/servers/databases/transparentDataEncryption[*] |
properties.transparentDataEncryption[*].id | Microsoft.Sql/servers/databases/transparentDataEncryption[*].id |
properties.transparentDataEncryption[*].location | Microsoft.Sql/servers/databases/transparentDataEncryption[*].location |
properties.transparentDataEncryption[*].name | Microsoft.Sql/servers/databases/transparentDataEncryption[*].name |
properties.transparentDataEncryption[*].properties.status | Microsoft.Sql/servers/databases/transparentDataEncryption[*].status |
properties.transparentDataEncryption[*].type | Microsoft.Sql/servers/databases/transparentDataEncryption[*].type |
properties.useFreeLimit | Microsoft.Sql/servers/databases/useFreeLimit |
properties.zoneRedundant | Microsoft.Sql/servers/databases/zoneRedundant |
sku | Microsoft.Sql/servers/databases/sku |
sku.capacity | Microsoft.Sql/servers/databases/sku.capacity |
sku.family | Microsoft.Sql/servers/databases/sku.family |
sku.name | Microsoft.Sql/servers/databases/sku.name |
sku.name | Microsoft.Sql/servers/databases/requestedServiceObjectiveName |
sku.size | Microsoft.Sql/servers/databases/sku.size |
sku.tier | Microsoft.Sql/servers/databases/sku.tier |
sku.tier | Microsoft.Sql/servers/databases/edition |