az sql

Manage databases.

Manage a database's auditing policy.

Gets a database's blob auditing policy.

Update a database's auditing policy.

Manage sensitivity classifications.

Delete the sensitivity classification of a given column.

Get the sensitivity classifications of a given database.

Manage sensitivity classification recommendations.

Disable sensitivity recommendations for a given column (recommendations are enabled by default on all columns).

Enable sensitivity recommendations for a given column (recommendations are enabled by default on all columns).

List the recommended sensitivity classifications of a given database.

Get the sensitivity classification of a given column.

Update a columns's sensitivity classification.

Create a copy of a database.

Create a database.

Delete a database.

Export a database to a bacpac.

Imports a bacpac into an existing database.

List databases a server or elastic pool.

Gets a list of deleted databases that can be restored.

Show database editions available for the currently active subscription.

Returns database usages.

Manage SQL database long term retention backups.

Delete a long term retention backup.

List the long term retention backups for a location, server or database.

Restore a long term retention backup to a new database.

Get a long term retention backup for a database.

Place the CLI in a waiting state until a condition of the database is met.

Manage SQL database long term retention policy.

Update long term retention settings for a database.

Show the long term retention policy for a database.

Manage operations on a database.

Cancels the asynchronous operation on the database.

Gets a list of operations performed on the database.

Rename a database.

Manage replication between databases.

Create a database as a readable secondary replica of an existing database.

Permanently stop data replication between two database replicas.

List the replicas of a database and their replication status.

Set the primary replica database by failing over from the current primary replica database.

Create a new database by restoring from a backup.

Get the details for a database.

Generates a connection string to a database.

Manage a database's transparent data encryption.

Returns a database's transparent data encryption operation result.

Sets a database's transparent data encryption configuration.

Gets a database's transparent data encryption configuration.

Manage a database's threat detection policies.

Gets a database's threat detection policy.

Update a database's threat detection policy.

Update a database.

Manage data warehouses.

Create a data warehouse.

Delete a data warehouse.

List data warehouses for a server.

Pauses a datawarehouse.

Resumes a datawarehouse.

Get the details for a data warehouse.

Update a data warehouse.

Manage elastic pools.

Create an elastic pool.

Deletes an elastic pool.

Gets all elastic pools in a server.

Gets a list of databases in an elastic pool.

List elastic pool editions available for the active subscription.

Manage operations on an elastic pool.

Cancels the asynchronous operation on the elastic pool.

Gets a list of operations performed on the elastic pool.

Gets an elastic pool.

Update an elastic pool.

Manage SQL Failover Groups.

Creates a failover group.

Deletes a failover group.

Lists the failover groups in a server.

Set the primary of the failover group by failing over all databases from the current primary server.

Gets a failover group.

Updates the failover group.

Manage SQL Instance Failover Groups.

Creates an instance failover group between two connected managed instances.

Deletes a failover group.

Set the primary of the instance failover group by failing over all databases from the current primary managed instance.

Gets a failover group.

Updates the instance failover group.

Manage instance pools.

Create an instance pool.

Delete an instance pool.

List available instance pools.

Get the details for an instance pool.

Update an instance pool.

Wait for an instance pool to reach a desired state.

Gets all subscription usage metrics in a given location.

Manage SQL managed instances.

Manage a managed instance's Active Directory administrator.

Creates a new managed instance Active Directory administrator.

Deletes an existing managed instance Active Directory Administrator.

Returns a list of managed instance Active Directory Administrators.

Updates an existing managed instance Active Directory administrator.

Create a managed instance.

Delete a managed instance.

Failover a managed instance.

Manage a SQL Instance's keys.

Creates a SQL Instance key.

Deletes a SQL Instance key.

Gets a list of managed instance keys.

Shows a SQL Instance key.

List available managed instances.

Manage operations on a managed instance.

Cancels the asynchronous operation on the managed instance.

Gets a list of operations performed on the managed instance.

Gets a management operation on a managed instance.

Get the details for a managed instance.

Manage a SQL Instance's encryption protector.

Sets the SQL Instance's encryption protector.

Gets a managed instance encryption protector.

Update a managed instance.

Manage SQL managed instance databases.

Create a managed database.

Delete a managed database.

List managed databases on a managed instance.

List restorable deleted managed databases.

Manage SQL Managed Instance database long term retention backups.

Delete a long term retention backup.

List the long term retention backups for a location, instance or database.

Restore a long term retention backup to a new database.

Get a long term retention backup for a managed database.

Place the CLI in a waiting state until a condition of the managed database is met.

Manage SQL Managed Instance database long term retention policy.

Update long term retention settings for a managed database.

Show the long term retention policy for a managed database.

Restore a managed database.

Manage SQL Managed Instance database backup short term retention policy.

Update short term retention for automated backups on a single database.

Show short term retention for automated backups on a single database.

Get the details for a managed database.

Manage SQL servers.

Manage a server's Active Directory administrator.

Create a new server Active Directory administrator.

Deletes the Azure Active Directory administrator with the given name.

Gets a list of Azure Active Directory administrators in a server.

Update an existing server Active Directory administrator.

Manage a server's auditing policy.

Gets a server's blob auditing policy.

Update a server's auditing policy.

Manage a server's connection policy.

Gets a server's secure connection policy.

Updates a server's secure connection policy.

Create a server.

Deletes a server.

Manage a server's DNS aliases.

Creates a server dns alias.

Deletes the server DNS alias with the given name.

Gets a list of server DNS aliases for a server.

Sets a server to which DNS alias should point.

Gets a server DNS alias.

Manage a server's firewall rules.

Create a firewall rule.

Deletes a firewall rule.

List a server's firewall rules.

Shows the details for a firewall rule.

Update a firewall rule.

Manage a server's keys.

Creates a server key.

Deletes a server key.

Gets a list of server keys.

Shows a server key.

List available servers.

Returns server usages.

Gets a server.

Manage a server's encryption protector.

Sets the server's encryption protector.

Gets a server encryption protector.

Update a server.

Manage a server's virtual network rules.

Create a virtual network rule to allows access to an Azure SQL server.

Deletes the virtual network rule with the given name.

Gets a list of virtual network rules in a server.

Gets a virtual network rule.

Update a virtual network rule.

Place the CLI in a waiting state until a condition of the SQL server is met.

Gets a subscription usage metric.

Manage SQL virtual clusters.

Delete a virtual cluster.

List available virtual clusters.

Get the details for a virtual cluster.

Manage SQL virtual machines.

Adds SQL virtual machine to a SQL virtual machine group.

Creates a SQL virtual machine.

Deletes a SQL virtual machine.

Manage SQL virtual machine groups.

Manage SQL availability group listeners.

Creates an availability group listener.

Deletes an availability group listener.

Lists all availability group listeners in a SQL virtual machine group.

Gets an availability group listener.

Updates an availability group listener.

Creates a SQL virtual machine group.

Deletes a SQL virtual machine group.

Lists all SQL virtual machine groups in a resource group or subscription.

Gets a SQL virtual machine group.

Updates a SQL virtual machine group if there are not SQL virtual machines attached to the group.

Lists all SQL virtual machines in a resource group or subscription.

Remove SQL virtual machine from its current SQL virtual machine group.

Gets a SQL virtual machine.

Updates the properties of a SQL virtual machine.