sql-data-warehouse-stored-procedures.md

title	SQL Data Warehouse Stored Procedures | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.service	sql-data-warehouse
ms.subservice	design
ms.reviewer
ms.topic	language-reference
dev_langs	TSQL
ms.assetid	02e04dfe-d565-4e45-b427-b8e89c958ba3
author	ronortloff
ms.author	rortloff
monikerRange	= azure-sqldw-latest || = sqlallproducts-allversions

SQL Data Warehouse Stored Procedures

[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-xxx-md]

[!INCLUDEssSDW] provides built-in procedures that you can use to perform operations related to database roles. [!INCLUDEssSDW] includes the following system procedures:

sp_datatype_info_90 (SQL Data Warehouse)

sp_pdw_add_network_credentials (SQL Data Warehouse)

sp_pdw_database_encryption (SQL Data Warehouse)

sp_pdw_database_encryption_regenerate_system_keys (SQL Data Warehouse)

sp_pdw_log_user_data_masking (SQL Data Warehouse)

sp_pdw_remove_network_credentials (SQL Data Warehouse)

sp_special_columns_100 (SQL Data Warehouse)

Note

Some additional system stored procedures are used only within an instance of [!INCLUDEssNoVersion] or through client APIs and are not intended for general customer use. These procedures are listed at System Stored Procedures (Transact-SQL). These procedures are subject to change and compatibility is not guaranteed. All procedures on the list are not available in [!INCLUDEssSDW].

See Also

System Stored Functions (Transact-SQL)
Data Types (Transact-SQL)