Operations - List

Služba:

SQL Database

Verze rozhraní API:

2025-01-01

Zobrazí seznam všech dostupných operací rozhraní SQL REST API.

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

Parametry identifikátoru URI

Name	V	Vyžadováno	Typ	Description
api-version	query	True	string minLength: 1	Verze rozhraní API, která se má použít pro tuto operaci.

Odpovědi

Name	Typ	Description
200 OK	OperationListResult	Operace Azure byla úspěšně dokončena.
Other Status Codes	ErrorResponse	Neočekávaná chybová odpověď

Zabezpečení

azure_auth

Azure Active Directory OAuth2 Flow.

Typ: oauth2
Tok: implicit
URL autorizace: https://login.microsoftonline.com/common/oauth2/authorize

Rozsahy

Name	Description
user_impersonation	zosobnění uživatelského účtu

Příklady

Lists all of the available SQL Rest API operations

Ukázkový požadavek

HTTP

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

Ukázková odpověď

Stavový kód:

200

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

Definice

Name	Description
ErrorAdditionalInfo	Další informace o chybě správy prostředků
ErrorDetail	Podrobnosti o chybě.
ErrorResponse	Chybová odpověď
Operation	Definice operace rozhraní SQL REST API
OperationDisplay	Zobrazí metadata přidružená k operaci.
OperationListResult	Výsledek požadavku na výpis operací SQL
OperationOrigin	Zamýšlený vykonavatel operace.

ErrorAdditionalInfo

Objekt

Další informace o chybě správy prostředků

Name	Typ	Description
info	object	Další informace.
type	string	Další typ informací.

ErrorDetail

Objekt

Podrobnosti o chybě.

Name	Typ	Description
additionalInfo	ErrorAdditionalInfo[]	Další informace o chybě.
code	string	Kód chyby.
details	ErrorDetail[]	Podrobnosti o chybě.
message	string	Chybová zpráva.
target	string	Cíl chyby.

ErrorResponse

Objekt

Chybová odpověď

Name	Typ	Description
error	ErrorDetail	Objekt chyby.

Operation

Objekt

Definice operace rozhraní SQL REST API

Name	Typ	Description
display	OperationDisplay	Lokalizované informace o zobrazení pro tuto konkrétní operaci nebo akci.
name	string	Název operace prováděné s tímto konkrétním objektem.
origin	OperationOrigin	Zamýšlený vykonavatel operace.
properties		Další popisy operace

OperationDisplay

Objekt

Zobrazí metadata přidružená k operaci.

Name	Typ	Description
description	string	Lokalizovaný popis operace.
operation	string	Lokalizovaný popisný název operace.
provider	string	Lokalizovaná popisná forma názvu poskytovatele prostředků.
resource	string	Lokalizovaná popisná forma typu prostředku související s touto akcí nebo operací.

OperationListResult

Objekt

Výsledek požadavku na výpis operací SQL

Name	Typ	Description
nextLink	string	Odkaz na načtení další stránky výsledků
value	Operation[]	Pole výsledků

OperationOrigin

Výčet

Zamýšlený vykonavatel operace.

Hodnota	Description
user	uživatel
system	systém