[wp-hackers] WordPress MU category tables

[Brian Layman]

Your best bet is probably just to check out each version and look at the
$tables array in wp-incudes/wp-db.php and that will give you the accurate
list of tables for that version: e.g.:
	/**
	 * List of WordPress tables
	 *
	 * @since {@internal Version Unknown}}
	 * @access private
	 * @var array
	 */
	var $tables = array('users', 'usermeta', 'posts', 'categories',
'post2cat', 'comments', 'links', 'link2cat', 'options',
			'postmeta', 'terms', 'term_taxonomy',
'term_relationships', 'commentmeta');

	/**
	 * List of deprecated WordPress tables
	 *
	 * @since 2.9.0
	 * @access private
	 * @var array
	 */
	var $old_tables = array('categories', 'post2cat', 'link2cat');

Now you  may wish to use your loop in order to get any tables added by
plugins, but beyond that the $tables variable should help you along...

Brian Layman