SqlManagementClient Class

Reference

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: 'TokenCredential', subscription_id: str, base_url: str | None = None, **kwargs: Any)

Parameters

Name	Description
credential Required	TokenCredential 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 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() -> None

Share via