catalog.delete_environment_reference(SSISDB 数据库)catalog.delete_environment_reference (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 an environment reference from a project in the Integration ServicesIntegration Services catalog.


delete_environment_reference [ @reference_id = ] reference_id  


[ @reference_id = ] reference_id [ @reference_id = ] reference_id
环境引用的唯一标识符。The unique identifier of the environment reference. reference_id 为 bigint 。The reference_id is bigint.

返回代码值Return Code Value

0(成功)0 (success)

结果集Result Sets



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

  • 针对项目的 MODIFY 权限MODIFY permission on the project

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

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

错误和警告Errors and Warnings

下面的列表描述了一些可能引发错误或警告的情况:The following list describes some conditions that may raise an error or warning:

  • 环境引用标识符无效The environment reference identifier is not valid

  • 用户没有相应的权限The user does not have the appropriate permissions