| title | The Azure CLI: Create a single database |
|---|---|
| description | Use this Azure CLI example script to create a single database. |
| services | sql-database |
| ms.service | sql-database |
| ms.subservice | deployment-configuration |
| ms.custom | sqldbrb=1, devx-track-azurecli |
| ms.devlang | azurecli |
| ms.topic | sample |
| author | WilliamDAssafMSFT |
| ms.author | wiassaf |
| ms.reviewer | kendralittle, mathoma |
| ms.date | 12/06/2021 |
[!INCLUDEappliesto-sqldb]
This Azure CLI script example creates a single database in Azure SQL Database and configures a server-level firewall rule. After the script has been successfully run, the database can be accessed from all Azure services and the configured IP address.
If you choose to install and use the CLI locally, this topic requires that you are running the Azure CLI version 2.0 or later. Run az --version to find the version. If you need to install or upgrade, see Install the Azure CLI.
[!INCLUDE quickstarts-free-trial-note]
subscription="<subscriptionId>" # add subscription here
az account set -s $subscription # ...or use 'az login'
:::code language="code-azurecli" source="~/azure_cli_scripts/sql-database/create-and-configure-database/create-and-configure-database.sh" range="4-33":::
Use the following command to remove the resource group and all resources associated with it.
az group delete --name $resourceGroup
This script uses the following commands. Each command in the table links to command-specific documentation.
| Command | Description |
|---|---|
| az sql server | Server commands |
| az sql server firewall | Server firewall commands. |
| az sql db | Database commands. |
For more information on the Azure CLI, see Azure CLI documentation.
Additional SQL Database CLI script samples can be found in the Azure SQL Database documentation.