RT information
| RT |
microsoft.sql/servers/databases
|
| RT display name |
Azure SQL Database
|
RT type only
(without RP) |
servers/databases
|
| RT sub- Resource types |
sub-Resource types: 83
|
| RT schema |
RT schema API versions: 21
|
| All Microsoft Azure RTs |
AzResourceTypesAdvertizer |
Aliases and Azure Policy
Aliases |
aliases: 135
|
Azure Policy |
Azure Policy definitions: 33
• if: 33
• then.deployment: 1
• then.details: 0
• then.existenceCondition: 0
• then.operations: 0
|
RBAC Operations and Roles & Roles related operation actions
RBAC operations |
RBAC operations: 12
• RBAC operationType action: 9
• RBAC operationType delete: 1
• RBAC operationType read: 1
• RBAC operationType write: 1
|
RBAC Roles & Operation actions |
Unique RBAC Roles: 21
• RBAC Roles with action operationType: 5
• RBAC Roles with delete operationType: 7
• RBAC Roles with read operationType: 21
• RBAC Roles with write operationType: 7
|
Capabilities & Locations
Diagnostic logs |
True
log-categories
|
Diagnostic metrics |
True
metrics
|
Customer-managed key (CMK) [experimental] |
True
• Microsoft Learn
• Enforce Encryption with a customer-managed key (CMK) at scale
|
System-Assigned-Resource-Identity |
False
|
Cross-ResourceGroup-Resource-Move |
True
|
Cross-Subscription-Resource-Move |
True
|
Tags |
True
|
Extension |
False
|
Private-Endpoint |
False
|
Supported Locations for Private-Endpoint |
n/a
|
| Non supported Locations for Private-Endpoint |
n/a
|
Location |
True
|
Locations |
Locations: 43
australiacentral, australiaeast, australiasoutheast, brazilsouth, canadacentral, canadaeast, centralindia, centralus, eastasia, eastus, eastus2, francecentral, germanywestcentral, indonesiacentral, israelcentral, italynorth, japaneast, japanwest, koreacentral, koreasouth, mexicocentral, newzealandnorth, northcentralus, northeurope, norwayeast, polandcentral, qatarcentral, southafricanorth, southcentralus, southeastasia, southindia, spaincentral, swedencentral, switzerlandnorth, uaenorth, uksouth, ukwest, westcentralus, westeurope, westindia, westus, westus2, westus3
|
| Not locations |
Not locations: 54
asia, asiapacific, australia, australiacentral2, brazil, brazilsoutheast, brazilus, canada, centraluseuap, centralusstage, eastasiastage, eastus2euap, eastus2stage, eastusstage, eastusstg, europe, france, francesouth, germany, germanynorth, global, india, indonesia, israel, italy, japan, jioindiacentral, jioindiawest, korea, mexico, newzealand, northcentralusstage, norway, norwaywest, poland, qatar, singapore, southafrica, southafricawest, southcentralusstage, southcentralusstg, southeastasiastage, spain, sweden, switzerland, switzerlandwest, taiwan, uae, uaecentral, uk, unitedstates, unitedstateseuap, westus2stage, westusstage
|
|
|
Infrastructure as Code (IaC)
ARM (Azure Resource Manager) templates |
ARM (Azure Resource Manager) template API versions: 21
• latest
|
Bicep templates |
Bicep template API versions: 21
• latest
|
Terraform provider |
Terraform providers: 1
• mssql_database
|
AzAPI Terraform templates |
AzAPI Terraform template API versions: 21
• latest
|
Pulumi provider |
Pulumi providers: 1
• sql/database
|
OpenTofu provider |
OpenTofu TF providers: 1
• mssql_database
|
Azure Verified Modules (AVM) Bicep |
n/a
|
Azure Verified Modules (AVM) Terraform |
n/a
|
REST-API (Representational State Transfer - Application Programming Interface)
| REST-API versions |
REST-API versions: 27
• 2024-08-01-preview
• 2024-05-01-preview
• 2023-08-01-preview
• 2023-08-01
• 2023-05-01-preview
• 2023-02-01-preview
• 2022-11-01-preview
• 2022-08-01-preview
• 2022-05-01-preview
• 2022-02-01-preview
• 2021-11-01-preview
• 2021-11-01
• 2021-08-01-preview
• 2021-05-01-preview
• 2021-02-01-preview
• 2020-11-01-preview
• 2020-08-01-preview
• 2020-02-02-preview
• 2019-06-01-preview
• 2018-06-01-preview
• 2017-10-01-preview
• 2017-03-01-preview
• 2015-05-01-preview
• 2015-01-01
• 2014-04-01-preview
• 2014-04-01
• 2014-01-01
|
| REST-API version default |
n/a
|
| API profiles |
n/a
|
Resource naming
Azure Naming Tool |
The Azure Naming Tool was created to help administrators define and manage their naming conventions, while providing a simple interface for users to generate a compliant name.
|
| Resource naming details |
{
"property": "",
"ShortName": "sqldb",
"scope": "server",
"lengthMin": "1",
"lengthMax": "128",
"validText": "",
"invalidText": "Angle brackets, asterisk, percent sign, ampersand, colon, backslash, slash, and question mark. Can't end with period or space.",
"invalidCharacters": "<>*%&:/?",
"invalidCharactersStart": "",
"invalidCharactersEnd": ". ",
"invalidCharactersConsecutive": "",
"regx": "^(?!.*[\\.]$)(?!.* $)[^<>\\*%&:\\/\\?]{1,128}$",
"staticValues": ""
}
|
|
Resource provider (RP) - Microsoft SQL Database [Microsoft.Sql]
