wheels db drop

wheels db drop

⚠️ Note: This command depends on configuration values. Please verify your database configuration before executing it.

Drop an existing database.

Synopsis

wheels db drop [--datasource=<name>] [--environment=<env>] [--database=<dbname>] [--force]

Description

The wheels db drop command permanently deletes a database. This is a destructive operation that cannot be undone. By default, it requires confirmation unless the --force flag is used.

Options

Option	Type	Default	Description
datasource	string	Current datasource	Specify which datasource’s database to drop. If not provided, uses the default datasource from your Wheels configuration.
environment	string	Current environment	Specify the environment to use. Defaults to the current environment.
database	string	wheels_dev	Specify the database name to drop. Note for Oracle: Database names cannot contain hyphens. Use underscores instead (e.g., myapp_dev not myapp-dev).
force	boolean	false	Skip the confirmation prompt. Useful for scripting.

Examples:

# Use specific datasource
wheels db drop --datasource=myapp_dev

# Specify environment
wheels db drop --environment=testing

# Custom database name
wheels db drop --database=myapp_test

# Force drop without confirmation
wheels db drop --force

Examples

Basic Usage

Drop database with confirmation:

wheels db drop
# Will prompt: Are you sure you want to drop the database 'myapp_dev'? Type 'yes' to confirm:

Force Drop

Drop without confirmation:

wheels db drop --force

Drop Test Database

wheels db drop --datasource=myapp_test --environment=testing --force

Drop SQLite Database

Drop file-based SQLite database:

# Using existing datasource
wheels db drop --datasource=myapp_dev

# With confirmation prompt
wheels db drop --datasource=sqlite_app

Output:

==================================================
              Database Drop Process
==================================================
[WARNING]: This will permanently drop the database!

Datasource:               db_app
Environment:              development
--------------------------------------------------
Database Type:            H2
Database Name:            mydb_app
--------------------------------------------------
Are you sure you want to drop the database 'mydb_app'? Type 'yes' to confirm:

If server is running, it will automatically stop and retry:

[WARN] Server is running - stopping it to release database lock...
[OK] SQLite database dropped successfully!

Safety Features

1. Confirmation Required: By default, you must type “yes” to confirm
2. Production Warning: Extra warning when dropping production databases
3. Clear Messaging: Shows database name and environment before dropping

Database-Specific Behavior

MySQL/MariaDB

• Uses DROP DATABASE IF EXISTS statement
• Connects to information_schema to execute command
• Automatically handles active connections

PostgreSQL

• Terminates existing connections before dropping
• Uses DROP DATABASE IF EXISTS statement
• Connects to postgres system database

SQL Server

• Sets database to single-user mode to close connections
• Uses DROP DATABASE IF EXISTS statement
• Connects to master system database

Oracle

• Drops USER/schema (Oracle’s equivalent of a database)
• Uses DROP USER ... CASCADE to remove all objects
• Supports Oracle 12c+ with Container Database (CDB) architecture
• Uses _ORACLE_SCRIPT session variable for non-C## users
• Important: Database names cannot contain hyphens (use underscores)
• Cannot drop system users (SYS, SYSTEM, ADMIN, XDB, etc.)

H2

• Deletes database files (.mv.db, .lock.db, .trace.db)
• Shows which files were deleted
• No server connection required

SQLite

• File-based deletion - removes database and auxiliary files
• Deletes main database file (.db extension)
• Automatically deletes auxiliary files:
  • .db-wal (Write-Ahead Log)
  • .db-shm (Shared Memory)
  • .db-journal (Rollback Journal)
• Handles file locking automatically:
  • Detects if application server is running
  • Stops server automatically if file is locked
  • Retries deletion up to 5 times with 1-second delays
  • Provides clear error messages if deletion fails
• Recommendation: Stop server before dropping: box server stop
• No network connection required (file-based)
• Clean output with minimal messages

Warning

This operation is irreversible! Always ensure you have backups before dropping a database.

Best Practices

1. Always backup first:

   wheels db dump --output=backup-before-drop.sql
   wheels db drop

2. Use —force carefully: Only in scripts where you’re certain

3. Double-check environment: Especially important for production

Error Messages

”Database not found”

The database doesn’t exist. No action needed.

”Access denied”

The database user doesn’t have permission to drop databases. Grant DROP privileges to the user.

”Database in use”

Some databases prevent dropping while connections are active. The command attempts to close connections automatically.

”Invalid Oracle identifier” (Oracle-specific)

Database name contains invalid characters. Oracle usernames can only contain letters, numbers, and underscores.

Fix: Use underscores instead of hyphens:

# Wrong
wheels db drop --database=my-app-dev

# Correct
wheels db drop --database=my_app_dev

“ORA-01918: user does not exist” (Oracle-specific)

The Oracle user/schema doesn’t exist. No action needed.

”ORA-28014: cannot drop administrative user” (Oracle-specific)

Attempting to drop an Oracle system user. System users like SYS, SYSTEM, ADMIN, XDB cannot be dropped.

Fix: Verify you’re targeting the correct database. System users are protected and cannot be removed.

”Database file is locked” (SQLite-specific)

The SQLite database file cannot be deleted because it’s currently in use.

Fix:

# Stop the server first
box server stop

# Wait a moment for file handles to release
# Then try again
wheels db drop

The command will automatically attempt to:

1. Detect if the server is running
2. Stop the server
3. Retry deletion up to 5 times
4. Wait 1 second between retries

If the error persists:

• Close any database tools (DB Browser for SQLite, etc.)
• Check if another process has the file open
• Wait a few seconds and try again

”No SQLite database files found” (SQLite-specific)

The SQLite database file doesn’t exist at the expected location.

This is normal if:

• The database was already dropped
• The database was never created
• A different database path is configured

No action needed.

”File still locked after stopping server” (SQLite-specific)

The database file remains locked even after stopping the server.

Fix:

1. Wait 10-30 seconds for Windows to release the file handle
2. Close any open database management tools
3. Check Task Manager for lingering processes
4. Try the command again

Related Commands

• wheels db create - Create a new database
• wheels db reset - Drop and recreate database
• wheels db dump - Backup before dropping