Operations - List

Referensi

Service:: SQL Database

API Version:: 2021-11-01

Lists semua operasi SQL Rest API yang tersedia.

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

Parameter URI

Nama	Dalam	Diperlukan	Jenis	Deskripsi
api-version	query	True	string	Versi API yang digunakan untuk permintaan.

Respons

Nama	Jenis	Deskripsi
200 OK	OperationListResult	Berhasil mengambil operasi.
Other Status Codes		Respons Kesalahan: ***

Contoh

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"
      }
    }
  ]
}

Definisi

Nama	Deskripsi
Operation	Definisi operasi SQL REST API.
OperationDisplay	Tampilkan metadata yang terkait dengan operasi.
OperationListResult	Hasil permintaan untuk mencantumkan operasi SQL.
OperationOrigin	Pelaksana operasi yang dimaksudkan.

Operation

Definisi operasi SQL REST API.

Nama	Jenis	Deskripsi
display	OperationDisplay	Informasi tampilan yang dilokalkan untuk operasi/tindakan tertentu ini.
name	string	Nama operasi yang sedang dilakukan pada objek khusus ini.
origin	OperationOrigin	Pelaksana operasi yang dimaksudkan.
properties	object	Deskripsi tambahan untuk operasi.

OperationDisplay

Tampilkan metadata yang terkait dengan operasi.

Nama	Jenis	Deskripsi
description	string	Deskripsi ramah yang dilokalkan untuk operasi.
operation	string	Nama ramah yang dilokalkan untuk operasi.
provider	string	Bentuk ramah yang dilokalkan dari nama penyedia sumber daya.
resource	string	Bentuk ramah yang dilokalkan dari jenis sumber daya yang terkait dengan tindakan/operasi ini.

OperationListResult

Hasil permintaan untuk mencantumkan operasi SQL.

Nama	Jenis	Deskripsi
nextLink	string	Tautan untuk mengambil halaman hasil berikutnya.
value	Operation[]	Array hasil.

OperationOrigin

Pelaksana operasi yang dimaksudkan.

Nama	Jenis	Deskripsi
system	string
user	string