你当前正在访问 Microsoft Azure Global Edition 技术文档网站。如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

Operations - List

参考

Service:: SQL Database

API Version:: 2021-11-01

列出所有可用的 SQL Rest API 操作。

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

URI 参数

名称	在	必需	类型	说明
api-version	query	True	string	要用于请求的 API 版本。

响应

名称	类型	说明
200 OK	OperationListResult	已成功检索到的操作。
Other Status Codes		错误响应： ***

示例

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

定义

名称	说明
Operation	SQL REST API 操作定义。
OperationDisplay	显示与操作关联的元数据。
OperationListResult	列出 SQL 操作的请求的结果。
OperationOrigin	操作的预期执行程序。

Operation

SQL REST API 操作定义。

名称	类型	说明
display	OperationDisplay	此特定操作/操作的本地化显示信息。
name	string	正在对此特定对象执行的操作的名称。
origin	OperationOrigin	操作的预期执行程序。
properties	object	操作的其他说明。

OperationDisplay

显示与操作关联的元数据。

名称	类型	说明
description	string	操作的本地化友好说明。
operation	string	操作的本地化友好名称。
provider	string	资源提供程序名称的本地化友好形式。
resource	string	与此操作/操作相关的资源类型的本地化友好形式。

OperationListResult

列出 SQL 操作的请求的结果。

名称	类型	说明
nextLink	string	用于检索下一页结果的链接。
value	Operation[]	结果数组。

OperationOrigin

操作的预期执行程序。

名称	类型	说明
system	string
user	string