az sql

Manage Azure SQL Databases and Data Warehouses.

Commands

az sql db Manage databases.
az sql db audit-policy Manage a database's auditing policy.
az sql db audit-policy show Gets a database's blob auditing policy.
az sql db audit-policy update Update a database's auditing policy.
az sql db copy Create a copy of a database.
az sql db create Create a database.
az sql db delete Delete a database.
az sql db export Export a database to a bacpac.
az sql db import Imports a bacpac into an existing database.
az sql db list List databases a server or elastic pool.
az sql db list-deleted Gets a list of deleted databases that can be restored.
az sql db list-editions Show database editions available for the currently active subscription.
az sql db list-usages Returns database usages.
az sql db op Manage operations on a database.
az sql db op cancel Cancels the asynchronous operation on the database.
az sql db op list Gets a list of operations performed on the database.
az sql db replica Manage replication between databases.
az sql db replica create Create a database as a readable secondary replica of an existing database.
az sql db replica delete-link Permanently stop data replication between two database replicas.
az sql db replica list-links List the replicas of a database and their replication status.
az sql db replica set-primary Set the primary replica database by failing over from the current primary replica database.
az sql db restore Create a new database by restoring from a backup.
az sql db show Get the details for a database.
az sql db show-connection-string Generates a connection string to a database.
az sql db tde Manage a database's transparent data encryption.
az sql db tde list-activity Returns a database's transparent data encryption operation result.
az sql db tde set Sets a database's transparent data encryption configuration.
az sql db tde show Gets a database's transparent data encryption configuration.
az sql db threat-policy Manage a database's threat detection policies.
az sql db threat-policy show Gets a database's threat detection policy.
az sql db threat-policy update Update a database's threat detection policy.
az sql db update Update a database.
az sql dw Manage data warehouses.
az sql dw create Create a data warehouse.
az sql dw delete Delete a data warehouse.
az sql dw list List data warehouses for a server.
az sql dw pause Pauses a data warehouse.
az sql dw resume Resumes a data warehouse.
az sql dw show Get the details for a data warehouse.
az sql dw update Update a data warehouse.
az sql elastic-pool Manage elastic pools.
az sql elastic-pool create Create an elastic pool.
az sql elastic-pool delete Deletes the elastic pool.
az sql elastic-pool list Returns a list of elastic pools in a server.
az sql elastic-pool list-dbs Returns a list of databases in an elastic pool.
az sql elastic-pool list-editions List elastic pool editions available for the active subscription.
az sql elastic-pool show Gets an elastic pool.
az sql elastic-pool update Update an elastic pool.
az sql list-usages Gets all subscription usage metrics in a given location.
az sql server Manage SQL servers.
az sql server ad-admin Manage a server's Active Directory administrator.
az sql server ad-admin create Create a new server Active Directory administrator.
az sql server ad-admin delete Deletes an existing server Active Directory Administrator.
az sql server ad-admin list Returns a list of server Administrators.
az sql server ad-admin update Update an existing server Active Directory administrator.
az sql server conn-policy Manage a server's connection policy.
az sql server conn-policy show Gets a server's secure connection policy.
az sql server conn-policy update Updates a server's secure connection policy.
az sql server create Create a server.
az sql server delete Deletes a server.
az sql server firewall-rule Manage a server's firewall rules.
az sql server firewall-rule create Create a firewall rule.
az sql server firewall-rule delete Deletes a firewall rule.
az sql server firewall-rule list List a server's firewall rules.
az sql server firewall-rule show Shows the details for a firewall rule.
az sql server firewall-rule update Update a firewall rule.
az sql server key Manage a server's keys.
az sql server key create Creates a server key.
az sql server key delete Deletes a server key.
az sql server key list Gets a list of server keys.
az sql server key show Shows a server key.
az sql server list List available servers.
az sql server list-usages Returns server usages.
az sql server show Gets a server.
az sql server tde-key Manage a server's encryption protector.
az sql server tde-key set Sets the server's encryption protector.
az sql server tde-key show Gets a server encryption protector.
az sql server update Update a server.
az sql server vnet-rule Manage a server's virtual network rules.
az sql server vnet-rule create Create a virtual network rule to allows access to an Azure SQL server.
az sql server vnet-rule delete Deletes the virtual network rule with the given name.
az sql server vnet-rule list Gets a list of virtual network rules in a server.
az sql server vnet-rule show Gets a virtual network rule.
az sql server vnet-rule update Update a virtual network rule.
az sql show-usage Gets a subscription usage metric.

az sql list-usages

Gets all subscription usage metrics in a given location.

az sql list-usages --location

Required Parameters

--location -l

Location. You can configure the default location using az configure --defaults location=<location>.

az sql show-usage

Gets a subscription usage metric.

az sql show-usage --location
--usage

Required Parameters

--location -l

Location. You can configure the default location using az configure --defaults location=<location>.

--usage -u

Name of usage metric to return.