catalog.object_versions(SSISDB 数据库)catalog.object_versions (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 目录中对象的版本。Displays the versions of objects in the Integration ServicesIntegration Services catalog. 在此版本中,此视图只支持项目的版本。In this release, only versions of projects are supported in this view.

列名Column name 数据类型Data type 描述Description
object_version_lsnobject_version_lsn bigintbigint 对象版本的唯一标识符 (ID)。The unique identifier (ID) of the object version. 此数字不保证是按顺序排列的。This number is not guaranteed to be sequential.
object_idobject_id bigintbigint 对象的唯一 ID。The unique ID of the object.
object_typeobject_type smallintsmallint 对象的类型。The type of object. 将针对项目显示值 20A value of 20 will be displayed for projects.
object_nameobject_name sysname(nvarchar(128))sysname(nvarchar(128)) 对象的名称。The name of the object.
descriptiondescription nvarchar(1024)nvarchar(1024) 项目的说明。The description of the project.
created_bycreated_by nvarchar(128)nvarchar(128) 向目录添加对象的用户名。The name of the user who added the object to the catalog.
created_timecreated_time datetimeoffsetdatetimeoffset 将对象添加到目录中的日期和时间。The date and time at which the object was added to the catalog.
restored_byrestored_by nvarchar(128)nvarchar(128) 还原对象的用户名。The name of the user who restored the object.
last_restored_timelast_restored_time datetimeoffsetdatetimeoffset 上次还原对象的日期和时间。The date and time at which the object was last restored.


此视图对于目录中的每个对象版本显示一行。This view displays a row for each version of an object in the catalog.


若要查看此视图中的行,您必须具有以下权限之一:To see rows in this view, you must have one of the following permissions:

  • 针对对象的 READ 权限READ permission on the object

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

  • sysadmin 服务器角色中的成员资格 。Membership in the sysadmin server role.


将实施行级安全性;只显示您有权查看的行。Row-level security is enforced; only rows that you have permission to view are displayed.