The Delete Schema Geodatabasetool deletes a schema geodatabase from a master sde geodatabase in Oracle.
The Delete Schema Geodatabasetool only works with geodatabases in Oracle.
Only the owner of the schema geodatabase can run the Delete Schema Geodatabase tool.
You must remove all data from the user-schema geodatabase before you can delete the geodatabase.
Specify the database connection (.sde) file for the schema geodatabase you want to delete. You must connect as the schema owner.
You can alter and run the following from a Python window to delete a user-schema geodatabase. This example connects through the database connection file firstname.lastname@example.org to delete a user-schema geodatabase.
import arcpy schema_gdb = "email@example.com" arcpy.DeleteSchemaGeodatabase_management(schema_gdb)
The following is a stand-alone script you can alter and run to delete a user-schema geodatabase:
# Set the necessary product code import arceditor # Import arcpy module import arcpy # Local variables: schema_gdb = "firstname.lastname@example.org" # Process: Delete Schema Geodatabase arcpy.DeleteSchemaGeodatabase_management(schema_gdb)
- ArcGIS Desktop Basic: No
- ArcGIS Desktop Standard: Yes
- ArcGIS Desktop Advanced: Yes