Operations - List

Referenz

Service:: SQL Database

API Version:: 2021-11-01

Zeigt eine Liste aller verfügbaren SQL-REST-API-Vorgänge.

GET https://management.azure.com/providers/Microsoft.Sql/operations?api-version=2021-11-01

URI-Parameter

Name	In	Erforderlich	Typ	Beschreibung
api-version	query	True	string	API-Version, die für die Anforderung verwendet werden soll.

Antworten

Name	Typ	Beschreibung
200 OK	OperationListResult	Vorgänge wurden erfolgreich abgerufen.
Other Status Codes		Fehlerantworten: ***

Beispiele

Lists all of the available SQL Rest API operations

GET https://management.azure.com/providers/Microsoft.Sql/operations?api-version=2021-11-01


import com.azure.core.util.Context;

/** Samples for Operations List. */
public final class Main {
    /*
     * x-ms-original-file:
     * specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/ListOperations.json
     */
    /**
     * Sample code: Lists all of the available SQL Rest API operations.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void
        listsAllOfTheAvailableSQLRestAPIOperations(com.azure.resourcemanager.AzureResourceManager azure) {
        azure.sqlServers().manager().serviceClient().getOperations().list(Context.NONE);
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample Response

Status code:: 200

{
  "value": [
    {
      "name": "Microsoft.Sql/servers/read",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Azure SQL Server",
        "operation": "List/Get Azure SQL Server(s)",
        "description": "Return the list of servers or gets the properties for the specified server."
      }
    },
    {
      "name": "Microsoft.Sql/servers/write",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Azure SQL Server",
        "operation": "Create/Update Azure SQL Server",
        "description": "Creates a server with the specified parameters or update the properties or tags for the specified server."
      }
    },
    {
      "name": "Microsoft.Sql/servers/delete",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Azure SQL Server",
        "operation": "Delete Azure SQL Server",
        "description": "Deletes an existing server."
      }
    },
    {
      "name": "Microsoft.Sql/servers/databases/read",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Azure SQL Database",
        "operation": "List/Get Azure SQL Database(s)",
        "description": "Return the list of databases or gets the properties for the specified database."
      }
    },
    {
      "name": "Microsoft.Sql/servers/databases/write",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Azure SQL Database",
        "operation": "Create/Update Azure SQL Database",
        "description": "Creates a database with the specified parameters or update the properties or tags for the specified database."
      }
    },
    {
      "name": "Microsoft.Sql/servers/databases/delete",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Azure SQL Database",
        "operation": "Delete Azure SQL Database",
        "description": "Deletes an existing database."
      }
    },
    {
      "name": "Microsoft.Sql/servers/elasticPools/databases/read",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Azure SQL Database",
        "operation": "Gets a list of databases for an elastic pool",
        "description": "Gets a list of databases for an elastic pool"
      }
    },
    {
      "name": "Microsoft.Sql/servers/databases/failover/action",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Azure SQL Database",
        "operation": "Issue failover on the database.",
        "description": "Customer initiated database failover."
      }
    },
    {
      "name": "Microsoft.Sql/servers/inaccessibleDatabases/read",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Azure SQL Database",
        "operation": "List Azure database(s) with inaccessible status in a logical server.",
        "description": "Return a list of inaccessible database(s) in a logical server."
      }
    },
    {
      "name": "Microsoft.Sql/servers/databases/pause/action",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Azure SQL Database",
        "operation": "Pause a Datawarehouse database.",
        "description": "Pause Azure SQL Datawarehouse Database"
      }
    },
    {
      "name": "Microsoft.Sql/servers/databases/resume/action",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Azure SQL Database",
        "operation": "Resume a Datawarehouse database.",
        "description": "Resume Azure SQL Datawarehouse Database"
      }
    },
    {
      "name": "Microsoft.Sql/locations/networkSecurityPerimeterAssociationProxyOperationResults/read",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Network Security Perimeter Association Proxy",
        "operation": "Get network security perimeter operation result",
        "description": "Get network security perimeter operation result"
      }
    },
    {
      "name": "Microsoft.Sql/locations/networkSecurityPerimeterAssociationProxyAzureAsyncOperation/read",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Network Security Perimeter Association Proxy",
        "operation": "Get network security perimeter proxy azure async operation",
        "description": "Get network security perimeter proxy azure async operation"
      }
    },
    {
      "name": "Microsoft.Sql/servers/restorableDroppedDatabases/read",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Restorable Dropped Database",
        "operation": "Get a list of restorable dropped databases",
        "description": "Get a list of databases that were dropped on a given server that are still within retention policy."
      }
    },
    {
      "name": "Microsoft.Sql/locations/networkSecurityPerimeterProxies/profileProxies/accessRuleProxies/read",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "NSP Access Rule Proxy",
        "operation": "Get NSP Access Rule Proxy",
        "description": "Get NSP Access Rule Proxy"
      }
    },
    {
      "name": "Microsoft.Sql/locations/networkSecurityPerimeterProxies/profileProxies/accessRuleProxies/write",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "NSP Access Rule Proxy",
        "operation": "Create or Update NSP Access Rule Proxy",
        "description": "Create or Update NSP Access Rule Proxy"
      }
    },
    {
      "name": "Microsoft.Sql/locations/networkSecurityPerimeterProxies/profileProxies/accessRuleProxies/delete",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "NSP Access Rule Proxy",
        "operation": "Delete NSP Access Rule Proxy",
        "description": "Delete NSP Access Rule Proxy"
      }
    },
    {
      "name": "Microsoft.Sql/locations/networkSecurityPerimeterProxies/profileProxies/read",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "NSP Profile Proxy",
        "operation": "Get NSP Profile Proxy",
        "description": "Get NSP Profile Proxy"
      }
    },
    {
      "name": "Microsoft.Sql/locations/networkSecurityPerimeterProxies/profileProxies/write",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "NSP Profile Proxy",
        "operation": "Create or Update NSP Profile Proxy",
        "description": "Create or Update NSP Profile Proxy"
      }
    },
    {
      "name": "Microsoft.Sql/locations/networkSecurityPerimeterProxies/profileProxies/delete",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "NSP Profile Proxy",
        "operation": "Delete NSP Proxy",
        "description": "Delete NSP Proxy"
      }
    },
    {
      "name": "Microsoft.Sql/locations/networkSecurityPerimeterProxies/read",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Network Security Perimeter Proxy",
        "operation": "Get NSP Proxy",
        "description": "Get NSP Proxy"
      }
    },
    {
      "name": "Microsoft.Sql/locations/networkSecurityPerimeterProxies/write",
      "display": {
        "provider": "Microsoft SQL Database",
        "resource": "Network Security Perimeter Proxy",
        "operation": "Create or Update NSP Proxy",
        "description": "Create or Update NSP Proxy"
      }
    }
  ]
}

Definitionen

Name	Beschreibung
Operation	SQL-REST-API-Vorgangsdefinition.
OperationDisplay	Zeigt metadaten an, die dem Vorgang zugeordnet sind.
OperationListResult	Ergebnis der Anforderung zum Auflisten von SQL-Vorgängen.
OperationOrigin	Der beabsichtigte Executor des Vorgangs.

Operation

SQL-REST-API-Vorgangsdefinition.

Name	Typ	Beschreibung
display	OperationDisplay	Die lokalisierten Anzeigeinformationen für diese bestimmte Operation/Aktion.
name	string	Der Name des Vorgangs, der für dieses bestimmte Objekt ausgeführt wird.
origin	OperationOrigin	Der beabsichtigte Executor des Vorgangs.
properties	object	Zusätzliche Beschreibungen für den Vorgang.

OperationDisplay

Zeigt metadaten an, die dem Vorgang zugeordnet sind.

Name	Typ	Beschreibung
description	string	Die lokalisierte benutzerfreundliche Beschreibung für den Vorgang.
operation	string	Der lokalisierte Anzeigename für den Vorgang.
provider	string	Die lokalisierte Anzeigeform des Ressourcenanbieternamens.
resource	string	Die lokalisierte benutzerfreundliche Form des Ressourcentyps, der sich auf diese Aktion bzw. diesen Vorgang bezieht.

OperationListResult

Ergebnis der Anforderung zum Auflisten von SQL-Vorgängen.

Name	Typ	Beschreibung
nextLink	string	Link zum Abrufen der nächsten Ergebnisseite.
value	Operation[]	Array von Ergebnissen.

OperationOrigin

Der beabsichtigte Executor des Vorgangs.

Name	Typ	Beschreibung
system	string
user	string