| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.topic | dev_langs | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
Azure Synapse Analytics stored procedures |
Azure Synapse Analytics stored procedures |
WilliamDAssafMSFT |
wiassaf |
randolphwest |
05/24/2023 |
sql |
reference |
|
=azure-sqldw-latest || =fabric |
[!INCLUDE asa-fabricse-fabricdw]
[!INCLUDE ssazuresynapse-md] and [!INCLUDE fabric] provide built-in procedures that you can use to perform operations related to database roles.
[!INCLUDE ssazuresynapse-md] 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 [!INCLUDE ssNoVersion] 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 [!INCLUDE ssazuresynapse-md].