ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

What is an archive view?

An archive view is a database view and triggers defined on a nonversioned table or feature class (collectively referred to as a dataset) that has been enabled for archiving. An archive view is created when you enable the dataset for archiving or when you enable SQL access on a nonversioned, archive-enabled dataset.

Archive views are used to perform insert, update, and delete operations on the underlying nonversioned, archive-enabled dataset. When you edit an archive view using SQL, the system fields that keep track of changes in the dataset are automatically updated, as are the ObjectID values.

The archive view does not automatically update globalID or GUID values. If your table contains a globalID or GUID field, you can use Next_GlobalID to insert a value to this field.

When queried, an archive view returns the current state of the underlying dataset. Therefore, if you want to use SQL to access archived records, query the table directly instead.

Note:

Archive views are not supported in DB2 on the z operating system or in PostgreSQL 9.0.x.

Related topics

  • The archive process
  • Is_Archive_Enabled
  • Archive_View_Name
  • Enable SQL access on geodatabase data from ArcGIS Desktop

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal