Skip to main content

Delete Database Sequence (Data Management Tools)

Summary

Deletes a database sequence from a geodatabase.

Usage

  • This tool can be used with file geodatabases, mobile geodatabases, and enterprise geodatabases in IBM Db2, Microsoft SQL Server, Oracle, PostgreSQL, and SAP HANA.

  • You can use the ListDatabaseSequences function to get a list of database sequences in a file geodatabase. This allows you to confirm the sequence name and review sequence properties before deleting it.

  • In an enterprise geodatabase, database sequence storage is handled by the database platform. Review the individual RDBMS platform documentation for more information. Integrated environments can be used to view the sequences.

Parameters

Label Explanation Data type

Input Workspace

The full path to the location of the file or mobile geodatabase from which you want to delete a sequence or the database connection file (.sde) to connect to the enterprise geodatabase from which you want to delete a sequence. The user specified in the database connection must have the following permissions in the database:

  • Db2—DBADM authority

  • Oracle—Must be the sequence owner or have the DROP ANY SEQUENCE system privilege

  • PostgreSQL—Must be the sequence owner

  • SAP HANA—Must be a standard user

  • SQL Server—ALTER OR CONTROL permission on the database schema where the sequence is stored

Workspace

Sequence Name

The name of the database sequence you want to delete. Once deleted, the sequence cannot be used to generate sequence IDs when called from existing custom applications or expressions.

String

Derived output

Label Explanation Data type

Deleted sequence from geodatabase

The updated input workspace.

Workspace

Environments

Current Workspace

Licensing information

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