Deletes a database sequence from a geodatabase.
This tool can be used with file geodatabases and 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.
The full path to the location of the file 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:
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.
The updated input workspace.
Delete the custom_sequence database sequence from an enterprise geodatabase.
import arcpy arcpy.DeleteDatabaseSequence_management(r"C:/myconnections/mygdb.sde", "custom_sequence")
Delete the my_ids sequence from a file geodatabase named myfilegdb.
import arcpy arcpy.DeleteDatabaseSequence_management(r"C:/geodatabases/myfilegdb.gdb", "my_ids")
- Basic: No
- Standard: Yes
- Advanced: Yes