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.

Inheritance
builtins.object
SqlManagementClient

Constructor

SqlManagementClient(credential: AsyncTokenCredential, subscription_id: str, base_url: Optional[str] = None, **kwargs: Any)

Parameters

credential
AsyncTokenCredential
Required

Credential needed for the client to connect to Azure.

subscription_id
str
Required

The subscription ID that identifies an Azure subscription.

base_url
str
default value: None

Service URL

polling_interval
int

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

Variables

recoverable_databases
RecoverableDatabasesOperations

RecoverableDatabasesOperations operations

server_connection_policies
ServerConnectionPoliciesOperations

ServerConnectionPoliciesOperations operations

data_masking_policies
DataMaskingPoliciesOperations

DataMaskingPoliciesOperations operations

data_masking_rules
DataMaskingRulesOperations

DataMaskingRulesOperations operations

geo_backup_policies
GeoBackupPoliciesOperations

GeoBackupPoliciesOperations operations

databases
DatabasesOperations

DatabasesOperations operations

elastic_pools
ElasticPoolsOperations

ElasticPoolsOperations operations

replication_links
ReplicationLinksOperations

ReplicationLinksOperations operations

server_communication_links
ServerCommunicationLinksOperations

ServerCommunicationLinksOperations operations

service_objectives
ServiceObjectivesOperations

ServiceObjectivesOperations operations

elastic_pool_activities
ElasticPoolActivitiesOperations

ElasticPoolActivitiesOperations operations

elastic_pool_database_activities
ElasticPoolDatabaseActivitiesOperations

ElasticPoolDatabaseActivitiesOperations operations

transparent_data_encryptions
TransparentDataEncryptionsOperations

TransparentDataEncryptionsOperations operations

transparent_data_encryption_activities
TransparentDataEncryptionActivitiesOperations

TransparentDataEncryptionActivitiesOperations operations

server_usages
ServerUsagesOperations

ServerUsagesOperations operations

extended_database_blob_auditing_policies
ExtendedDatabaseBlobAuditingPoliciesOperations

ExtendedDatabaseBlobAuditingPoliciesOperations operations

extended_server_blob_auditing_policies
ExtendedServerBlobAuditingPoliciesOperations

ExtendedServerBlobAuditingPoliciesOperations operations

server_blob_auditing_policies
ServerBlobAuditingPoliciesOperations

ServerBlobAuditingPoliciesOperations operations

database_blob_auditing_policies
DatabaseBlobAuditingPoliciesOperations

DatabaseBlobAuditingPoliciesOperations operations

database_advisors
DatabaseAdvisorsOperations

DatabaseAdvisorsOperations operations

database_automatic_tuning
DatabaseAutomaticTuningOperations

DatabaseAutomaticTuningOperations operations

database_columns
DatabaseColumnsOperations

DatabaseColumnsOperations operations

database_recommended_actions
DatabaseRecommendedActionsOperations

DatabaseRecommendedActionsOperations operations

database_schemas
DatabaseSchemasOperations

DatabaseSchemasOperations operations

database_security_alert_policies
DatabaseSecurityAlertPoliciesOperations

DatabaseSecurityAlertPoliciesOperations operations

database_tables
DatabaseTablesOperations

DatabaseTablesOperations operations

database_vulnerability_assessment_rule_baselines
DatabaseVulnerabilityAssessmentRuleBaselinesOperations

DatabaseVulnerabilityAssessmentRuleBaselinesOperations operations

database_vulnerability_assessments
DatabaseVulnerabilityAssessmentsOperations

DatabaseVulnerabilityAssessmentsOperations operations

database_vulnerability_assessment_scans
DatabaseVulnerabilityAssessmentScansOperations

DatabaseVulnerabilityAssessmentScansOperations operations

data_warehouse_user_activities
DataWarehouseUserActivitiesOperations

DataWarehouseUserActivitiesOperations operations

deleted_servers
DeletedServersOperations

DeletedServersOperations operations

elastic_pool_operations
ElasticPoolOperationsOperations

ElasticPoolOperationsOperations operations

encryption_protectors
EncryptionProtectorsOperations

EncryptionProtectorsOperations operations

failover_groups
FailoverGroupsOperations

FailoverGroupsOperations operations

firewall_rules
FirewallRulesOperations

FirewallRulesOperations operations

instance_failover_groups
InstanceFailoverGroupsOperations

InstanceFailoverGroupsOperations operations

instance_pools
InstancePoolsOperations

InstancePoolsOperations operations

job_agents
JobAgentsOperations

JobAgentsOperations operations

job_credentials
JobCredentialsOperations

JobCredentialsOperations operations

job_executions
JobExecutionsOperations

JobExecutionsOperations operations

jobs
JobsOperations

JobsOperations operations

job_step_executions
JobStepExecutionsOperations

JobStepExecutionsOperations operations

job_steps
JobStepsOperations

JobStepsOperations operations

job_target_executions
JobTargetExecutionsOperations

JobTargetExecutionsOperations operations

job_target_groups
JobTargetGroupsOperations

JobTargetGroupsOperations operations

job_versions
JobVersionsOperations

JobVersionsOperations operations

capabilities
CapabilitiesOperations

CapabilitiesOperations operations

long_term_retention_backups
LongTermRetentionBackupsOperations

LongTermRetentionBackupsOperations operations

long_term_retention_managed_instance_backups
LongTermRetentionManagedInstanceBackupsOperations

LongTermRetentionManagedInstanceBackupsOperations operations

long_term_retention_policies
LongTermRetentionPoliciesOperations

LongTermRetentionPoliciesOperations operations

maintenance_window_options
MaintenanceWindowOptionsOperations

MaintenanceWindowOptionsOperations operations

maintenance_windows
MaintenanceWindowsOperations

MaintenanceWindowsOperations operations

managed_backup_short_term_retention_policies
ManagedBackupShortTermRetentionPoliciesOperations

ManagedBackupShortTermRetentionPoliciesOperations operations

managed_database_columns
ManagedDatabaseColumnsOperations

ManagedDatabaseColumnsOperations operations

managed_database_queries
ManagedDatabaseQueriesOperations

ManagedDatabaseQueriesOperations operations

managed_database_restore_details
ManagedDatabaseRestoreDetailsOperations

ManagedDatabaseRestoreDetailsOperations operations

managed_databases
ManagedDatabasesOperations

ManagedDatabasesOperations operations

managed_database_schemas
ManagedDatabaseSchemasOperations

ManagedDatabaseSchemasOperations operations

managed_database_security_alert_policies
ManagedDatabaseSecurityAlertPoliciesOperations

ManagedDatabaseSecurityAlertPoliciesOperations operations

managed_database_security_events
ManagedDatabaseSecurityEventsOperations

ManagedDatabaseSecurityEventsOperations operations

managed_database_sensitivity_labels
ManagedDatabaseSensitivityLabelsOperations

ManagedDatabaseSensitivityLabelsOperations operations

managed_database_recommended_sensitivity_labels
ManagedDatabaseRecommendedSensitivityLabelsOperations

ManagedDatabaseRecommendedSensitivityLabelsOperations operations

managed_database_tables
ManagedDatabaseTablesOperations

ManagedDatabaseTablesOperations operations

managed_database_transparent_data_encryption
ManagedDatabaseTransparentDataEncryptionOperations

ManagedDatabaseTransparentDataEncryptionOperations operations

managed_database_vulnerability_assessment_rule_baselines
ManagedDatabaseVulnerabilityAssessmentRuleBaselinesOperations

ManagedDatabaseVulnerabilityAssessmentRuleBaselinesOperations operations

managed_database_vulnerability_assessments
ManagedDatabaseVulnerabilityAssessmentsOperations

ManagedDatabaseVulnerabilityAssessmentsOperations operations

managed_database_vulnerability_assessment_scans
ManagedDatabaseVulnerabilityAssessmentScansOperations

ManagedDatabaseVulnerabilityAssessmentScansOperations operations

managed_instance_administrators
ManagedInstanceAdministratorsOperations

ManagedInstanceAdministratorsOperations operations

managed_instance_azure_ad_only_authentications
ManagedInstanceAzureADOnlyAuthenticationsOperations

ManagedInstanceAzureADOnlyAuthenticationsOperations operations

managed_instance_encryption_protectors
ManagedInstanceEncryptionProtectorsOperations

ManagedInstanceEncryptionProtectorsOperations operations

managed_instance_keys
ManagedInstanceKeysOperations

ManagedInstanceKeysOperations operations

managed_instance_long_term_retention_policies
ManagedInstanceLongTermRetentionPoliciesOperations

ManagedInstanceLongTermRetentionPoliciesOperations operations

managed_instance_operations
ManagedInstanceOperationsOperations

ManagedInstanceOperationsOperations operations

managed_instance_private_endpoint_connections
ManagedInstancePrivateEndpointConnectionsOperations

ManagedInstancePrivateEndpointConnectionsOperations operations

managed_instance_private_link_resources
ManagedInstancePrivateLinkResourcesOperations

ManagedInstancePrivateLinkResourcesOperations operations

managed_instances
ManagedInstancesOperations

ManagedInstancesOperations operations

managed_instance_tde_certificates
ManagedInstanceTdeCertificatesOperations

ManagedInstanceTdeCertificatesOperations operations

managed_instance_vulnerability_assessments
ManagedInstanceVulnerabilityAssessmentsOperations

ManagedInstanceVulnerabilityAssessmentsOperations operations

managed_restorable_dropped_database_backup_short_term_retention_policies
ManagedRestorableDroppedDatabaseBackupShortTermRetentionPoliciesOperations

ManagedRestorableDroppedDatabaseBackupShortTermRetentionPoliciesOperations operations

managed_server_security_alert_policies
ManagedServerSecurityAlertPoliciesOperations

ManagedServerSecurityAlertPoliciesOperations operations

operations
Operations

Operations operations

operations_health
OperationsHealthOperations

OperationsHealthOperations operations

private_endpoint_connections
PrivateEndpointConnectionsOperations

PrivateEndpointConnectionsOperations operations

private_link_resources
PrivateLinkResourcesOperations

PrivateLinkResourcesOperations operations

recoverable_managed_databases
RecoverableManagedDatabasesOperations

RecoverableManagedDatabasesOperations operations

restore_points
RestorePointsOperations

RestorePointsOperations operations

sensitivity_labels
SensitivityLabelsOperations

SensitivityLabelsOperations operations

recommended_sensitivity_labels
RecommendedSensitivityLabelsOperations

RecommendedSensitivityLabelsOperations operations

server_advisors
ServerAdvisorsOperations

ServerAdvisorsOperations operations

server_automatic_tuning
ServerAutomaticTuningOperations

ServerAutomaticTuningOperations operations

server_azure_ad_administrators
ServerAzureADAdministratorsOperations

ServerAzureADAdministratorsOperations operations

server_azure_ad_only_authentications
ServerAzureADOnlyAuthenticationsOperations

ServerAzureADOnlyAuthenticationsOperations operations

server_dev_ops_audit_settings
ServerDevOpsAuditSettingsOperations

ServerDevOpsAuditSettingsOperations operations

server_dns_aliases
ServerDnsAliasesOperations

ServerDnsAliasesOperations operations

server_keys
ServerKeysOperations

ServerKeysOperations operations

server_operations
ServerOperationsOperations

ServerOperationsOperations operations

server_security_alert_policies
ServerSecurityAlertPoliciesOperations

ServerSecurityAlertPoliciesOperations operations

server_trust_groups
ServerTrustGroupsOperations

ServerTrustGroupsOperations operations

server_vulnerability_assessments
ServerVulnerabilityAssessmentsOperations

ServerVulnerabilityAssessmentsOperations operations

sql_agent
SqlAgentOperations

SqlAgentOperations operations

subscription_usages
SubscriptionUsagesOperations

SubscriptionUsagesOperations operations

sync_agents
SyncAgentsOperations

SyncAgentsOperations operations

sync_groups
SyncGroupsOperations

SyncGroupsOperations operations

sync_members
SyncMembersOperations

SyncMembersOperations operations

tde_certificates
TdeCertificatesOperations

TdeCertificatesOperations operations

time_zones
TimeZonesOperations

TimeZonesOperations operations

virtual_clusters
VirtualClustersOperations

VirtualClustersOperations operations

virtual_network_rules
VirtualNetworkRulesOperations

VirtualNetworkRulesOperations operations

workload_classifiers
WorkloadClassifiersOperations

WorkloadClassifiersOperations operations

workload_groups
WorkloadGroupsOperations

WorkloadGroupsOperations operations

backup_short_term_retention_policies
BackupShortTermRetentionPoliciesOperations

BackupShortTermRetentionPoliciesOperations operations

database_extensions
DatabaseExtensionsOperations

DatabaseExtensionsOperations operations

database_operations
DatabaseOperationsOperations

DatabaseOperationsOperations operations

database_usages
DatabaseUsagesOperations

DatabaseUsagesOperations operations

ledger_digest_uploads
LedgerDigestUploadsOperations

LedgerDigestUploadsOperations operations

outbound_firewall_rules
OutboundFirewallRulesOperations

OutboundFirewallRulesOperations operations

restorable_dropped_databases
RestorableDroppedDatabasesOperations

RestorableDroppedDatabasesOperations operations

restorable_dropped_managed_databases
RestorableDroppedManagedDatabasesOperations

RestorableDroppedManagedDatabasesOperations operations

servers
ServersOperations

ServersOperations operations

usages
UsagesOperations

UsagesOperations operations

Methods

close

close

async close() -> None