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
|
The subscription ID that identifies an Azure subscription. |
|
base_url
|
Service URL Default value: None
|
Keyword-Only Parameters
| Name | Description |
|---|---|
|
polling_interval
|
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