SQL - 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 Updates a database's auditing policy.
az sql db copy Creates a copy of an existing database.
az sql db create Creates a database.
az sql db delete Deletes a database or data warehouse.
az sql db export Exports a database to a bacpac.
az sql db import Imports a bacpac into an existing database.
az sql db list Lists all databases and data warehouses in a server, or all databases in an elastic pool.
az sql db list-editions Shows database editions that are available for your subscription.
az sql db list-usages Returns database usages.
az sql db replica Manage replication between databases.
az sql db replica create Creates a database as a readable secondary replica of an existing database.
az sql db replica delete-link Permanently stops data replication between two database replicas.
az sql db replica list-links Lists the replicas of a database and corresponding replication status.
az sql db replica set-primary Sets which replica database is primary by failing over from the current primary replica database.
az sql db restore Creates a new database by restoring from a database backup.
az sql db show Gets a database or data warehouse.
az sql db threat-policy Manage a database's threat detection policy.
az sql db threat-policy show Gets a database's threat detection policy.
az sql db threat-policy update Updates a database's threat detection policy.
az sql db update Updates a database.
az sql dw Manage data warehouses.
az sql dw create Creates a data warehouse.
az sql dw delete Deletes a database or data warehouse.
az sql dw list Lists all data warehouses in a server.
az sql dw pause Pauses a data warehouse.
az sql dw resume Resumes a data warehouse.
az sql dw show Gets a database or data warehouse.
az sql dw update Updates a data warehouse.
az sql elastic-pool Manage elastic pools. An elastic pool is an allocation of CPU, IO, and memory resources. Databases inside the pool share these resources.
az sql elastic-pool create Creates 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 Shows elastic pool editions that are available for your subscription.
az sql elastic-pool show Gets an elastic pool.
az sql elastic-pool update Updates an elastic pool.
az sql server Manage servers. Servers contain databases, data warehouses, and elastic pools.
az sql server ad-admin Manage a server's Active Directory administrator.
az sql server ad-admin create Creates 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 Updates an existing server Active Directory administrator.
az sql server create Creates 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 Creates a firewall rule.
az sql server firewall-rule delete Deletes a firewall rule.
az sql server firewall-rule list Lists the firewall rules.
az sql server firewall-rule show Shows the detail of a firewall rule.
az sql server firewall-rule update Updates a firewall rule.
az sql server list Lists servers.
az sql server list-usages Returns server usages.
az sql server show Gets a server.
az sql server update Updates a server.