How to Find a Joomla Extension's Database Tables
Start with the extension identity
First identify the extension's type and element in Joomla. Components commonly use an element such as com_example, while modules and plugins use their own extension identifiers. The extension name alone is not enough to safely identify database ownership because third-party developers choose their own table names and some extensions do not create custom tables at all.
Check the extension package or installed manifest
The most reliable place to learn whether an extension creates database tables is its manifest and installation SQL. Joomla extension manifests can define install, update, and uninstall SQL. For components, SQL files are commonly shipped inside the administrator portion of the extension package, often under an sql directory.
Look for CREATE TABLE statements
Open the extension's install SQL and search for CREATE TABLE. Joomla extension SQL normally uses the #__ placeholder instead of hard-coding the site's actual table prefix. For example, #__example_items represents a real table whose name begins with the prefix configured for that Joomla installation.
Translate #__ to the site's real prefix
Find the site's configured database prefix in configuration.php and substitute it mentally for #__. If the prefix is abcd_, an extension table written as #__example_items in the package will exist as abcd_example_items in the database. Confirm the database name as well as the prefix before inspecting production tables.
Review update SQL for tables added later
An extension can add, rename, or alter tables in later releases. Joomla manifests can define a schemas path containing numbered update SQL files, so checking only the original install SQL can miss database objects introduced after the first version. Review the update SQL through the version actually installed.
Do not assume every similar table belongs to the extension
A matching name is useful evidence but not proof of ownership. Another extension, an older release, or a previous migration can leave similarly named tables behind. Before deleting, renaming, or repairing a table, verify ownership against the extension package, manifest, update history, and vendor documentation.
Document what you find
Record the extension element, extension ID, installed version, real table prefix, and confirmed table names. That gives you a defensible map for backups, migrations, troubleshooting, and uninstall testing without relying on guesses based only on table naming.
Need More Help with Joomla?
Still having trouble? Open a support ticket with QuantaCade Support and we'll be happy to help where we can.
Support priority is given to QuantaCade products, services, and customers. However, we're also happy to assist fellow Joomla users with general Joomla questions and troubleshooting when possible.
QuantaCade is an independent Joomla extension developer and is not official Joomla support. Some issues involving third-party extensions, hosting environments, server configurations, or other systems outside our development control may be beyond what we're able to resolve.