SqlManagementClient Class

The Azure SQL Database management API provides a RESTful set of web services that interact with Azure SQL Database services to manage your databases. The API enables you to create, retrieve, update, and delete databases.

Constructor

SqlManagementClient(credential: AsyncTokenCredential, subscription_id: str, base_url: str | None = None, **kwargs: Any)

Parameters

Name Description
credential
Required

Credential needed for the client to connect to Azure.

subscription_id
Required
str

The subscription ID that identifies an Azure subscription.

base_url
str

Service URL

Default value: None

Keyword-Only Parameters

Name Description
polling_interval
int

Default waiting time between two polls for LRO operations if no Retry-After header is present.

Variables

Name Description
recoverable_databases

RecoverableDatabasesOperations operations

server_connection_policies

ServerConnectionPoliciesOperations operations

data_masking_policies

DataMaskingPoliciesOperations operations

data_masking_rules

DataMaskingRulesOperations operations

geo_backup_policies

GeoBackupPoliciesOperations operations

databases

DatabasesOperations operations

elastic_pools

ElasticPoolsOperations operations

replication_links

ReplicationLinksOperations operations

server_communication_links

ServerCommunicationLinksOperations operations

service_objectives

ServiceObjectivesOperations operations

elastic_pool_activities

ElasticPoolActivitiesOperations operations

elastic_pool_database_activities

ElasticPoolDatabaseActivitiesOperations operations

transparent_data_encryptions

TransparentDataEncryptionsOperations operations

transparent_data_encryption_activities

TransparentDataEncryptionActivitiesOperations operations

server_usages

ServerUsagesOperations operations

extended_database_blob_auditing_policies

ExtendedDatabaseBlobAuditingPoliciesOperations operations

extended_server_blob_auditing_policies

ExtendedServerBlobAuditingPoliciesOperations operations

server_blob_auditing_policies

ServerBlobAuditingPoliciesOperations operations

database_blob_auditing_policies

DatabaseBlobAuditingPoliciesOperations operations

database_advisors

DatabaseAdvisorsOperations operations

database_automatic_tuning

DatabaseAutomaticTuningOperations operations

database_columns

DatabaseColumnsOperations operations

database_recommended_actions

DatabaseRecommendedActionsOperations operations

database_schemas

DatabaseSchemasOperations operations

database_security_alert_policies

DatabaseSecurityAlertPoliciesOperations operations

database_tables

DatabaseTablesOperations operations

database_vulnerability_assessment_rule_baselines

DatabaseVulnerabilityAssessmentRuleBaselinesOperations operations

database_vulnerability_assessments

DatabaseVulnerabilityAssessmentsOperations operations

database_vulnerability_assessment_scans

DatabaseVulnerabilityAssessmentScansOperations operations

data_warehouse_user_activities

DataWarehouseUserActivitiesOperations operations

deleted_servers

DeletedServersOperations operations

elastic_pool_operations

ElasticPoolOperationsOperations operations

encryption_protectors

EncryptionProtectorsOperations operations

failover_groups

FailoverGroupsOperations operations

firewall_rules

FirewallRulesOperations operations

instance_failover_groups

InstanceFailoverGroupsOperations operations

instance_pools

InstancePoolsOperations operations

job_agents

JobAgentsOperations operations

job_credentials

JobCredentialsOperations operations

job_executions

JobExecutionsOperations operations

jobs

JobsOperations operations

job_step_executions

JobStepExecutionsOperations operations

job_steps

JobStepsOperations operations

job_target_executions

JobTargetExecutionsOperations operations

job_target_groups

JobTargetGroupsOperations operations

job_versions

JobVersionsOperations operations

capabilities

CapabilitiesOperations operations

long_term_retention_backups

LongTermRetentionBackupsOperations operations

long_term_retention_managed_instance_backups

LongTermRetentionManagedInstanceBackupsOperations operations

long_term_retention_policies

LongTermRetentionPoliciesOperations operations

maintenance_window_options

MaintenanceWindowOptionsOperations operations

maintenance_windows

MaintenanceWindowsOperations operations

managed_backup_short_term_retention_policies

ManagedBackupShortTermRetentionPoliciesOperations operations

managed_database_columns

ManagedDatabaseColumnsOperations operations

managed_database_queries

ManagedDatabaseQueriesOperations operations

managed_database_restore_details

ManagedDatabaseRestoreDetailsOperations operations

managed_databases

ManagedDatabasesOperations operations

managed_database_schemas

ManagedDatabaseSchemasOperations operations

managed_database_security_alert_policies

ManagedDatabaseSecurityAlertPoliciesOperations operations

managed_database_security_events

ManagedDatabaseSecurityEventsOperations operations

managed_database_sensitivity_labels

ManagedDatabaseSensitivityLabelsOperations operations

managed_database_recommended_sensitivity_labels

ManagedDatabaseRecommendedSensitivityLabelsOperations operations

managed_database_tables

ManagedDatabaseTablesOperations operations

managed_database_transparent_data_encryption

ManagedDatabaseTransparentDataEncryptionOperations operations

managed_database_vulnerability_assessment_rule_baselines

ManagedDatabaseVulnerabilityAssessmentRuleBaselinesOperations operations

managed_database_vulnerability_assessments

ManagedDatabaseVulnerabilityAssessmentsOperations operations

managed_database_vulnerability_assessment_scans

ManagedDatabaseVulnerabilityAssessmentScansOperations operations

managed_instance_administrators

ManagedInstanceAdministratorsOperations operations

managed_instance_azure_ad_only_authentications

ManagedInstanceAzureADOnlyAuthenticationsOperations operations

managed_instance_encryption_protectors

ManagedInstanceEncryptionProtectorsOperations operations

managed_instance_keys

ManagedInstanceKeysOperations operations

managed_instance_long_term_retention_policies

ManagedInstanceLongTermRetentionPoliciesOperations operations

managed_instance_operations

ManagedInstanceOperationsOperations operations

managed_instance_private_endpoint_connections

ManagedInstancePrivateEndpointConnectionsOperations operations

managed_instance_private_link_resources

ManagedInstancePrivateLinkResourcesOperations operations

managed_instances

ManagedInstancesOperations operations

managed_instance_tde_certificates

ManagedInstanceTdeCertificatesOperations operations

managed_instance_vulnerability_assessments

ManagedInstanceVulnerabilityAssessmentsOperations operations

managed_restorable_dropped_database_backup_short_term_retention_policies

ManagedRestorableDroppedDatabaseBackupShortTermRetentionPoliciesOperations operations

managed_server_security_alert_policies

ManagedServerSecurityAlertPoliciesOperations operations

operations

Operations operations

operations_health

OperationsHealthOperations operations

private_endpoint_connections

PrivateEndpointConnectionsOperations operations

private_link_resources

PrivateLinkResourcesOperations operations

recoverable_managed_databases

RecoverableManagedDatabasesOperations operations

restore_points

RestorePointsOperations operations

sensitivity_labels

SensitivityLabelsOperations operations

recommended_sensitivity_labels

RecommendedSensitivityLabelsOperations operations

server_advisors

ServerAdvisorsOperations operations

server_automatic_tuning

ServerAutomaticTuningOperations operations

server_azure_ad_administrators

ServerAzureADAdministratorsOperations operations

server_azure_ad_only_authentications

ServerAzureADOnlyAuthenticationsOperations operations

server_dev_ops_audit_settings

ServerDevOpsAuditSettingsOperations operations

server_dns_aliases

ServerDnsAliasesOperations operations

server_keys

ServerKeysOperations operations

server_operations

ServerOperationsOperations operations

server_security_alert_policies

ServerSecurityAlertPoliciesOperations operations

server_trust_groups

ServerTrustGroupsOperations operations

server_vulnerability_assessments

ServerVulnerabilityAssessmentsOperations operations

sql_agent

SqlAgentOperations operations

subscription_usages

SubscriptionUsagesOperations operations

sync_agents

SyncAgentsOperations operations

sync_groups

SyncGroupsOperations operations

sync_members

SyncMembersOperations operations

tde_certificates

TdeCertificatesOperations operations

time_zones

TimeZonesOperations operations

virtual_clusters

VirtualClustersOperations operations

virtual_network_rules

VirtualNetworkRulesOperations operations

workload_classifiers

WorkloadClassifiersOperations operations

workload_groups

WorkloadGroupsOperations operations

backup_short_term_retention_policies

BackupShortTermRetentionPoliciesOperations operations

database_extensions

DatabaseExtensionsOperations operations

database_operations

DatabaseOperationsOperations operations

database_usages

DatabaseUsagesOperations operations

ledger_digest_uploads

LedgerDigestUploadsOperations operations

outbound_firewall_rules

OutboundFirewallRulesOperations operations

restorable_dropped_databases

RestorableDroppedDatabasesOperations operations

restorable_dropped_managed_databases

RestorableDroppedManagedDatabasesOperations operations

servers

ServersOperations operations

usages

UsagesOperations operations

Methods

close

close

async close() -> None