| auto_pause_delay_in_minutes |
(Optional) Time in minutes after which database is automatically paused. A value of -1 means that automatic pause is disabled. This property is only settable for Serverless databases. |
number |
null |
no |
| collation |
(Optional) Specifies the collation of the database. Changing this forces a new resource to be created. |
string |
"SQL_Latin1_General_CP1_CI_AS" |
no |
| create_mode |
(Optional) The create mode of the database. Possible values are Copy, Default, OnlineSecondary, PointInTimeRestore, Recovery, Restore, RestoreExternalBackup, RestoreExternalBackupSecondary, RestoreLongTermRetentionBackup and Secondary. Mutually exclusive with import. Changing this forces a new resource to be created. Defaults to Default. |
string |
"Default" |
no |
| license_type |
(Optional) Specifies the license type applied to this database. Possible values are LicenseIncluded and BasePrice. |
string |
"LicenseIncluded" |
no |
| max_size_gb |
(Optional) The max size of the database in gigabytes. |
number |
250 |
no |
| name |
(Required) The name of the Microsoft SQL Server. This needs to be globally unique within Azure. Changing this forces a new resource to be created. |
string |
n/a |
yes |
| read_scale |
(Optional) If enabled, connections that have application intent set to readonly in their connection string may be routed to a readonly secondary replica. This property is only settable for Premium and Business Critical databases. |
bool |
true |
no |
| server_id |
(Required) The id of the MS SQL Server on which to create the database. Changing this forces a new resource to be created. |
string |
n/a |
yes |
| sku_name |
(Optional) Specifies the name of the SKU used by the database. For example, GP_S_Gen5_2,HS_Gen4_1,BC_Gen5_2, ElasticPool, Basic,S0, P2 ,DW100c, DS100. Changing this from the HyperScale service tier to another service tier will create a new resource. |
string |
"P2" |
no |
| tags |
(Optional) A mapping of tags to assign to the resource. |
map(any) |
{} |
no |