management-data-warehouse-stored-procedures-transact-sql.md

title	Management Data Warehouse Stored Procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	management data warehouse, data collector stored procedures
ms.assetid	bc492b18-6965-4bb5-8065-fe2641d29590
author	stevestein
ms.author	sstein
monikerRange	>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Management Data Warehouse Stored Procedures (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-all-md]

The data collector stores data and data collector type information in the management data warehouse. The following stored procedures are used to update data and change the tables in the management data warehouse.

core.sp_create_snapshot (Transact-SQL)	core.sp_update_data_source (Transact-SQL)
core.sp_add_collector_type (Transact-SQL)	core.sp_remove_collector_type (Transact-SQL)
core.sp_purge_data (Transact-SQL)

See Also

Data Collector Stored Procedures (Transact-SQL)