Operations - List
列出所有可用的 SQL Rest API作。
GET https://management.azure.com/providers/Microsoft.Sql/operations?api-version=2023-08-01URI 参数
| 名称 | 在 | 必需 | 类型 | 说明 | 
|---|---|---|---|---|
| api-version | query | True | string | 要用于请求的 API 版本。 | 
响应
| 名称 | 类型 | 说明 | 
|---|---|---|
| 200 OK | 已成功检索的作。 | |
| Other Status Codes | 错误响应: *** | 
示例
Lists all of the available SQL Rest API operations
示例请求
GET https://management.azure.com/providers/Microsoft.Sql/operations?api-version=2023-08-01
示例响应
{
  "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"
      }
    }
  ]
}定义
| 名称 | 说明 | 
|---|---|
| Error | 资源管理错误附加信息。 | 
| Error | 错误详细信息。 | 
| Error | 错误响应 | 
| Operation | SQL REST API作定义。 | 
| Operation | 显示与作关联的元数据。 | 
| Operation | 列出 SQL作的请求的结果。 | 
| Operation | 作的预期执行程序。 | 
ErrorAdditionalInfo  
			
			资源管理错误附加信息。
| 名称 | 类型 | 说明 | 
|---|---|---|
| info | object | 其他信息。 | 
| type | string | 其他信息类型。 | 
ErrorDetail 
			
			错误详细信息。
| 名称 | 类型 | 说明 | 
|---|---|---|
| additionalInfo | 错误附加信息。 | |
| code | string | 错误代码。 | 
| details | 错误详细信息。 | |
| message | string | 错误消息。 | 
| target | string | 错误目标。 | 
ErrorResponse 
			
			错误响应
| 名称 | 类型 | 说明 | 
|---|---|---|
| error | 错误对象。 | 
Operation
SQL REST API作定义。
| 名称 | 类型 | 说明 | 
|---|---|---|
| display | 此特定作/作的本地化显示信息。 | |
| name | string | 正在对此特定对象执行的作的名称。 | 
| origin | 作的预期执行程序。 | |
| properties | object | 作的其他说明。 | 
OperationDisplay 
			
			显示与作关联的元数据。
| 名称 | 类型 | 说明 | 
|---|---|---|
| description | string | 作的本地化友好说明。 | 
| operation | string | 作的本地化友好名称。 | 
| provider | string | 资源提供程序名称的本地化友好形式。 | 
| resource | string | 与此作/作相关的资源类型的本地化友好形式。 | 
OperationListResult  
			
			列出 SQL作的请求的结果。
| 名称 | 类型 | 说明 | 
|---|---|---|
| nextLink | string | 用于检索下一页结果的链接。 | 
| value | 结果数组。 | 
OperationOrigin 
			
			作的预期执行程序。
| 值 | 说明 | 
|---|---|
| user | |
| system |