Summary
The Delete Schema Geodatabasetool deletes a schema geodatabase from an Oracle database.
Usage
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.
Syntax
DeleteSchemaGeodatabase_management (input_database)
Parameter | Explanation | Data Type |
input_database | Specify the database connection (.sde) file for the schema geodatabase you want to delete. You must connect as the schema owner. | Workspace |
Code sample
DeleteSchemaGeodatabase example 1 (Python window)
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 land@ora11204.sde to delete a user-schema geodatabase.
import arcpy
schema_gdb = "usr/connections/land@ora11204.sde"
arcpy.DeleteSchemaGeodatabase_management(schema_gdb)
DeleteSchemaGeodatabase example 2 (stand-alone Python script)
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 = "usr/connections/land@ora11204.sde"
# Process: Delete Schema Geodatabase
arcpy.DeleteSchemaGeodatabase_management(schema_gdb)
Environments
Licensing information
- ArcGIS for Desktop Basic: No
- ArcGIS for Desktop Standard: Yes
- ArcGIS for Desktop Advanced: Yes