Select your language

Sign up

The Joomla database table prefix is the shared beginning of table names belonging to one installation. With the prefix abc_, the articles table is named abc_content.

Why prefixes exist

A prefix distinguishes table sets within one database. Joomla suggests a value during installation and stores it in configuration.php. Extension SQL templates can use #__, which Joomla database tools replace with the configured prefix.

Important limits

Different prefixes prevent name collisions but do not isolate sites that share database privileges. Changing a prefix requires coordinated table renaming and configuration updates. Editing configuration.php alone is not enough.

A random Joomla prefix does not replace updates, backups or access control. Keep a verifiable backup before changing database tables.

Newsletter Subscription
Enter your email address and we will keep you updated!

Joomla.center is not affiliated with or endorsed by the Joomla!® Project or Open Source Matters. The Joomla!® name and logo is used under a limited license granted by Open Source Matters, the trademark holder in the United States and other countries.