Azure Synapse Analytics Stored Procedures
Applies to: Azure Synapse Analytics SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric
Azure Synapse Analytics and Microsoft Fabric provide built-in procedures that you can use to perform operations related to database roles.
Azure Synapse Analytics includes the following system procedures:
- sp_pdw_add_network_credentials (Azure Synapse Analytics)
- sp_pdw_database_encryption (Azure Synapse Analytics)
- sp_pdw_database_encryption_regenerate_system_keys (Azure Synapse Analytics)
- sp_pdw_log_user_data_masking (Azure Synapse Analytics)
- sp_pdw_remove_network_credentials (Azure Synapse Analytics)
- sp_special_columns_100 (Azure Synapse Analytics)
Note
Some additional system stored procedures are used only within an instance of SQL Server or through client APIs and aren't intended for general customer use. These procedures are listed at System stored procedures (Transact-SQL). These procedures are subject to change and compatibility isn't guaranteed. All procedures on the list aren't available in Azure Synapse Analytics.
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for