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

Is_Versioned

  • Definition
  • Syntax
  • Return type
  • Examples

Definition

Is_Versioned takes a table as an input parameter and returns TRUE if the table is registered to participate in traditional versioning. If the table is not registered for traditional versioning, Is_Versioned returns FALSE. If the table is not registered with the geodatabase, Is_Versioned returns NOT REGISTERED. Be aware that if a table doesn't exist in the database (for example, if you mistyped the name), a message that the table is not registered is returned because Is_Versioned only checks the geodatabase system tables for the presence or absence of the table.

Syntax

<geodatabase administrator schema>.is_versioned (<table owner>, <table name>)

In most geodatabases, the geodatabase administrator schema is sde. However, it is dbo in dbo-schema geodatabases in SQL Server, and in user-schema geodatabases in Oracle, it is the name of the user's schema.

Return type

String

TRUE is returned if the specified table is registered with the geodatabase and has been registered for traditional versioning.

FALSE is returned if the specified table is registered with the geodatabase but has not been registered for traditional versioning.

NOT REGISTERED is returned if the specified table is not registered with the geodatabase, does not exist in the database, or you do not have access to the table.

Examples

The following are examples of using the Is_Versioned function in each supported database type.

The first example queries the laterals table owned by tech3 to determine if it participates in traditional versioning.

The second example queries the crews table owned by crewboss to determine if it participates in traditional versioning. Crews is not registered for traditional versioning; therefore, FALSE is returned.

The third example queries the service_areas table owned by dentry. The service_areas table is not registered with the geodatabase.

Db2

VALUES sde.is_versioned('TECH3', 'LATERALS')

TRUE
VALUES sde.is_versioned('CREWBOSS', 'CREWS')

FALSE
VALUES sde.is_versioned('DENTRY', 'SERVICE_AREAS')

NOT REGISTERED

Oracle

SELECT sde.gdb_util.is_versioned('TECH3', 'LATERALS')
FROM DUAL;

SDE.GDB_UTIL.IS_VERSIONED('TECH3', 'LATERALS')
--------------------------------------------------
TRUE
SELECT sde.gdb_util.is_versioned('CREWBOSS', 'CREWS')
FROM DUAL;

SDE.GDB_UTIL.IS_VERSIONED('CREWBOSS', 'CREWS')
--------------------------------------------------
FALSE
SELECT sde.gdb_util.is_versioned('DENTRY', 'SERVICE_AREAS')
FROM DUAL;

SDE.GDB_UTIL.IS_VERSIONED('DENTRY', 'SERVICE_AREAS')
----------------------------------------------------

NOT REGISTERED

PostgreSQL

SELECT sde.is_versioned('tech3', 'laterals');

TRUE
SELECT sde.is_versioned('crewboss', 'crews');

FALSE
SELECT sde.is_versioned('dentry', 'services_areas');

NOT REGISTERED

SQL Server

SELECT dbo.is_versioned('tech3', 'laterals');

TRUE
SELECT dbo.is_versioned('crewboss', 'crews');

FALSE
SELECT dbo.is_versioned('dentry', 'services_areas');

NOT REGISTERED

Related topics

  • Registering data as versioned
  • An overview of traditional versioning

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