共用方式為


Operations - List

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

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

URI 參數

名稱 位於 必要 類型 Description
api-version
query True

string

要用於要求的 API 版本。

回應

名稱 類型 Description
200 OK

OperationListResult

已成功擷取作業。

Other Status Codes

錯誤回應: ≦

範例

Lists all of the available SQL Rest API operations

Sample request

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

Sample response

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

定義

名稱 Description
Operation

SQL REST API 作業定義。

OperationDisplay

顯示與作業相關聯的元數據。

OperationListResult

列出 SQL 作業的要求結果。

OperationOrigin

作業的預定執行程式。

Operation

SQL REST API 作業定義。

名稱 類型 Description
display

OperationDisplay

這個特定作業/動作的當地語系化顯示資訊。

name

string

在這個特定物件上執行的作業名稱。

origin

OperationOrigin

作業的預定執行程式。

properties

object

作業的其他描述。

OperationDisplay

顯示與作業相關聯的元數據。

名稱 類型 Description
description

string

作業的當地語系化易記描述。

operation

string

作業的當地語系化易記名稱。

provider

string

資源提供者名稱的當地語系化易記形式。

resource

string

與這個動作/作業相關的資源類型當地語系化易記形式。

OperationListResult

列出 SQL 作業的要求結果。

名稱 類型 Description
nextLink

string

連結以擷取下一頁的結果。

value

Operation[]

結果陣列。

OperationOrigin

作業的預定執行程式。

名稱 類型 Description
system

string

user

string