Operations - List

服務:

SQL Database

API 版本:

2025-01-01

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

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

URI 參數

名稱	位於	必要	類型	Description
api-version	query	True	string minLength: 1	用於此作業的 API 版本。

回應

名稱	類型	Description
200 OK	OperationListResult	Azure 運作順利完成。
Other Status Codes	ErrorResponse	未預期的錯誤回應。

安全性

azure_auth

Azure Active Directory OAuth2 Flow.

類型: oauth2
Flow: implicit
授權 URL: https://login.microsoftonline.com/common/oauth2/authorize

範圍

名稱	Description
user_impersonation	模擬您的用戶帳戶

範例

Lists all of the available SQL Rest API operations

範例要求

HTTP

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

範例回覆

狀態碼:

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

定義

名稱	Description
ErrorAdditionalInfo	資源管理錯誤附加資訊。
ErrorDetail	錯誤詳細資料。
ErrorResponse	錯誤回應
Operation	SQL REST API 作業定義。
OperationDisplay	顯示與作業相關聯的元數據。
OperationListResult	列出 SQL 作業的要求結果。
OperationOrigin	作業的預期執行者。

ErrorAdditionalInfo

Object

資源管理錯誤附加資訊。

名稱	類型	Description
info	object	附加資訊。
type	string	其他資訊類型。

ErrorDetail

Object

錯誤詳細資料。

名稱	類型	Description
additionalInfo	ErrorAdditionalInfo[]	錯誤附加資訊。
code	string	錯誤碼。
details	ErrorDetail[]	錯誤詳情
message	string	錯誤訊息。
target	string	錯誤目標。

ErrorResponse

Object

錯誤回應

名稱	類型	Description
error	ErrorDetail	錯誤物件。

Operation

Object

SQL REST API 作業定義。

名稱	類型	Description
display	OperationDisplay	這個特定作業/動作的當地語系化顯示資訊。
name	string	在這個特定物件上執行的作業名稱。
origin	OperationOrigin	作業的預期執行者。
properties		作業的其他描述。

OperationDisplay

Object

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

名稱	類型	Description
description	string	作業的當地語系化易記描述。
operation	string	作業的當地語系化易記名稱。
provider	string	資源提供者名稱的當地語系化易記形式。
resource	string	與此動作/作業相關的資源類型當地語系化易記形式。

OperationListResult

Object

列出 SQL 作業的要求結果。

名稱	類型	Description
nextLink	string	連結以擷取下一頁的結果。
value	Operation[]	結果的陣列。

OperationOrigin

列舉型別

作業的預期執行者。

值	Description
user	使用者
system	系統