Is_Replicated

Definition

Is_Replicated takes a table as an input parameter and returns TRUE if the table participates in a geodatabase replica. If the table does not participate in a geodatabase replica, Is_Replicated returns FALSE.

Syntax

<geodatabase administrator schema>.is_replicated (<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

Examples

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

The first example queries the birds table owned by bio to determine if it participates in a replica.

The second example queries the species table owned by bio to determine if it participates in a replica. The species table is not replicated; therefore, FALSE is returned.

DB2

VALUES sde.is_replicated('BIO', 'BIRDS')

TRUE
VALUES sde.is_replicated('BIO', 'SPECIES')

FALSE

Oracle

SELECT sde.gdb_util.is_replicated('BIO', 'BIRDS')
FROM DUAL;

SDE.GDB_UTIL.IS_VERSIONED('BIO', 'BIRDS')
--------------------------------------------------
TRUE
SELECT sde.gdb_util.is_replicated('BIO', 'SPECIES')
FROM DUAL;

SDE.GDB_UTIL.IS_VERSIONED('BIO', 'SPECIES')
--------------------------------------------------
FALSE

PostgreSQL

SELECT sde.is_replicated('bio', 'birds');

true
SELECT sde.is_replicated('bio', 'species');

false

SQL Server

SELECT sde.is_replicated('bio', 'birds');

TRUE
SELECT sde.is_replicated('bio', 'species');

FALSE

Related Topics

6/19/2015