Skip to main content

Change Dataset Schema (Data Management Tools)

Summary

Moves a dataset in an enterprise geodatabase to a new database schema.

Usage

  • Only enterprise geodatabases in SQL Server are supported.

  • The input dataset must be registered with the geodatabase.

  • The database connection must have privileges to alter the schema of the dataset and its associated database objects.

  • The dataset cannot contain or participate in objects that do not support schema changes.

  • Any external references or services that use the dataset must be reestablished after running the tool.

Parameters

Label Explanation Data type

Input Dataset

The dataset for which the schema will be changed.

Table View; Feature Dataset

New Schema

The database schema that will be used to qualify the input dataset.

String

Derived output

Label Explanation Data type

Output Dataset

The input dataset qualified by the new database schema.

Table View; Feature Dataset

Environments

Current Workspace

Licensing information

  • Basic: Yes
  • Standard: Yes
  • Advanced: Yes