catalog.delete_folder(SSISDB 数据库)catalog.delete_folder (SSISDB Database)

适用范围:SQL Server,包括 Linux Azure SQL 数据库yesAzure SQL 数据仓库no并行数据仓库 APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

适用对象: yesSQL ServeryesAzure SQL 数据库noAzure SQL 数据仓库no并行数据仓库APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Integration ServicesIntegration Services 目录删除文件夹。Deletes a folder from the Integration ServicesIntegration Services catalog.


delete_folder [ @folder_name = ] folder_name  


[ @folder_name = ] folder_name [ @folder_name = ] folder_name
要删除的文件夹的名称。The name of the folder that is to be deleted. folder_namenvarchar(128)The folder_name is nvarchar(128).

返回代码值Return Code Value


结果集Result Sets



此存储过程需要下列权限之一:This stored procedure requires one of the following permissions:

  • ssis_admin 数据库角色的成员资格Membership to the ssis_admin database role

  • sysadmin 服务器角色的成员资格Membership to the sysadmin server role

错误和警告Errors and Warnings

将返回一条消息以确认删除文件夹。Returns a message to confirm the deletion of the folder.