你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn。
Operations - List
列出所有可用的 SQL Rest API 操作。
GET https://management.azure.com/providers/Microsoft.Sql/operations?api-version=2021-11-01
名称 | 在 | 必需 | 类型 | 说明 |
---|---|---|---|---|
api-version
|
query | True |
string |
要用于请求的 API 版本。 |
名称 | 类型 | 说明 |
---|---|---|
200 OK |
已成功检索到的操作。 |
|
Other Status Codes |
错误响应: *** |
示例请求
示例响应
{
"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 操作定义。 |
Operation |
显示与操作关联的元数据。 |
Operation |
列出 SQL 操作的请求的结果。 |
Operation |
操作的预期执行程序。 |
SQL REST API 操作定义。
名称 | 类型 | 说明 |
---|---|---|
display |
此特定操作/操作的本地化显示信息。 |
|
name |
string |
正在对此特定对象执行的操作的名称。 |
origin |
操作的预期执行程序。 |
|
properties |
object |
操作的其他说明。 |
显示与操作关联的元数据。
名称 | 类型 | 说明 |
---|---|---|
description |
string |
操作的本地化友好说明。 |
operation |
string |
操作的本地化友好名称。 |
provider |
string |
资源提供程序名称的本地化友好形式。 |
resource |
string |
与此操作/操作相关的资源类型的本地化友好形式。 |
列出 SQL 操作的请求的结果。
名称 | 类型 | 说明 |
---|---|---|
nextLink |
string |
用于检索下一页结果的链接。 |
value |
结果数组。 |
操作的预期执行程序。
名称 | 类型 | 说明 |
---|---|---|
system |
string |
|
user |
string |