How can I find out the current version of the CIVICRM database schema

884 Views Asked by At

How can I find out the current version of the civicrm database schema?

1

There are 1 best solutions below

3
On

Look in the civicrm_domain table for the column version - that'll tell you what version the database is in. (It's updated as one of the last steps in the upgrade process.)

SELECT version FROM civicrm_domain

If you have multiple CiviCRM domains running from the same data set, you'll see multiple entries, but for 99% of organizations, there'll just be the one result.

Meanwhile, if you want to see the codebase version (hopefully they're the same), it's in your civicrm directory in the file civicrm-version.php and displayed at the bottom of each page in the back end of CiviCRM.