Skip to content

Latest commit

 

History

History
65 lines (40 loc) · 1.99 KB

sql_database.html.markdown

File metadata and controls

65 lines (40 loc) · 1.99 KB
Raw
layout page_title sidebar_current description
azurerm
Azure Resource Manager: azurerm_sql_database
docs-azurerm-datasource-sql-database
Gets information about an existing SQL Azure Database.

Data Source: azurerm_sql_database

Use this data source to access information about an existing SQL Azure Database.

Example Usage

data "azurerm_sql_database" "example" {
  name                = "example_db"
  server_name         = "example_db_server"
  resource_group_name = "example-resources"
}

output "sql_database_id" {
  value = data.azurerm_sql_database.example.id
}

Argument Reference

  • name - (Required) The name of the SQL Database.

  • server_name - (Required) The name of the SQL Server.

  • resource_group_name - (Required) Specifies the name of the Resource Group where the Azure SQL Database exists.

Attributes Reference

  • id - The SQL Database ID.

  • collation - The name of the collation.

  • creation_date - The creation date of the SQL Database.

  • default_secondary_location - The default secondary location of the SQL Database.

  • edition - The edition of the database.

  • elastic_pool_name - The name of the elastic database pool the database belongs to.

  • failover_group_id - The ID of the failover group the database belongs to.

  • location - The location of the Resource Group in which the SQL Server exists.

  • name - The name of the database.

  • read_scale - Indicate if read-only connections will be redirected to a high-available replica.

  • requested_service_objective_id - The ID pertaining to the performance level of the database.

  • requested_service_objective_name - The name pertaining to the performance level of the database.

  • resource_group_name - The name of the resource group in which the database resides. This will always be the same resource group as the Database Server.

  • server_name - The name of the SQL Server on which to create the database.

  • tags - A mapping of tags assigned to the resource.