Delete Schema Geodatabase (Data Management)

Summary

Deletes a geodatabase from a user's schema in Oracle.

Usage

• The Delete Schema Geodatabase tool only works with user-geodatabases in Oracle; it cannot delete the master sde geodatabase.

• 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(input_database)

Parameter	Explanation	Data Type
input_database	The database connection (.sde) file for the user-schema geodatabase you want to delete. You must connect as the schema owner.	Workspace

Derived Output

Name	Explanation	Data Type
out_workspace	The updated input workspace.	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 [e-mail] to delete a user-schema geodatabase.

import arcpy
schema_gdb = "usr/connections/[e-mail]"
arcpy.DeleteSchemaGeodatabase_management(schema_gdb)

DeleteSchemaGeodatabase example 2 (stand-alone 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/[e-mail]"

# Process: Delete Schema Geodatabase
arcpy.DeleteSchemaGeodatabase_management(schema_gdb)

Environments

Current Workspace

Licensing information

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