Operations - List

Layanan:

SQL Database

Versi API:

2025-01-01

Mencantumkan semua operasi SQL Rest API yang tersedia.

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

Parameter URI

Nama	Dalam	Diperlukan	Jenis	Deskripsi
api-version	query	True	string minLength: 1	Versi API yang digunakan untuk operasi ini.

Respons

Nama	Jenis	Deskripsi
200 OK	OperationListResult	Operasi Azure berhasil diselesaikan.
Other Status Codes	ErrorResponse	Respons kesalahan tak terduga.

Keamanan

azure_auth

Alur OAuth2 Azure Active Directory.

Jenis: oauth2
Alur: implicit
URL Otorisasi: https://login.microsoftonline.com/common/oauth2/authorize

Cakupan

Nama	Deskripsi
user_impersonation	meniru akun pengguna Anda

Contoh

Lists all of the available SQL Rest API operations

Permintaan sampel

HTTP

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

Respon sampel

Kode status:

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

Definisi

Nama	Deskripsi
ErrorAdditionalInfo	Info tambahan kesalahan manajemen sumber daya.
ErrorDetail	Detail kesalahan.
ErrorResponse	Tanggapan kesalahan
Operation	Definisi operasi SQL REST API.
OperationDisplay	Tampilkan metadata yang terkait dengan operasi.
OperationListResult	Hasil permintaan untuk mencantumkan operasi SQL.
OperationOrigin	Pelaksana operasi yang dituju.

ErrorAdditionalInfo

Objek

Info tambahan kesalahan manajemen sumber daya.

Nama	Jenis	Deskripsi
info	object	Info tambahan.
type	string	Jenis info tambahan.

ErrorDetail

Objek

Detail kesalahan.

Nama	Jenis	Deskripsi
additionalInfo	ErrorAdditionalInfo[]	Info tambahan kesalahan.
code	string	Kode kesalahan.
details	ErrorDetail[]	Rincian kesalahan.
message	string	Pesan kesalahan.
target	string	Sasaran kesalahan.

ErrorResponse

Objek

Tanggapan kesalahan

Nama	Jenis	Deskripsi
error	ErrorDetail	Objek kesalahan.

Operation

Objek

Definisi operasi SQL REST API.

Nama	Jenis	Deskripsi
display	OperationDisplay	Informasi tampilan yang dilokalkan untuk operasi/ tindakan tertentu ini.
name	string	Nama operasi yang sedang dilakukan pada objek khusus ini.
origin	OperationOrigin	Pelaksana operasi yang dituju.
properties		Deskripsi tambahan untuk operasi.

OperationDisplay

Objek

Tampilkan metadata yang terkait dengan operasi.

Nama	Jenis	Deskripsi
description	string	Deskripsi ramah yang dilokalkan untuk operasi.
operation	string	Nama ramah yang dilokalkan untuk operasi.
provider	string	Bentuk ramah yang dilokalkan dari nama penyedia sumber daya.
resource	string	Bentuk ramah yang dilokalkan dari jenis sumber daya yang terkait dengan tindakan/operasi ini.

OperationListResult

Objek

Hasil permintaan untuk mencantumkan operasi SQL.

Nama	Jenis	Deskripsi
nextLink	string	Tautan untuk mengambil halaman hasil berikutnya.
value	Operation[]	Array hasil.

OperationOrigin

Enumerasi

Pelaksana operasi yang dituju.

Nilai	Deskripsi
user	pengguna
system	sistem