phpmyadmin - default to structure instead of browse

Add:

$cfg['DefaultTabTable'] = 'tbl_structure.php';

To either config.inc.php or config.default.php.

You can also change LeftDefaultTabTable which changes the icon. The options are:

• 'tbl_structure.php' = fields list
• 'tbl_sql.php' = SQL form
• 'tbl_select.php' = search page
• 'tbl_change.php' = insert row page
• 'sql.php' = browse page

If perchance you are using the "quick access icon" next to the table name in the navigation frame, this may be configured.

From the configuration file documentation:

$cfg['LeftDefaultTabTable'] string

Defines the tab displayed by default when clicking the small icon next to each table name in the navigation panel. Possible values: "tbl_structure.php", "tbl_sql.php", "tbl_select.php", "tbl_change.php" or "sql.php".

For MAMP 3.x the DefaultTabTable configuration parameter applies. It needs to be set in MAMP/bin/phpMyAdmin/config.inc.php, e.g.:

$cfg['DefaultTabTable'] = 'sql.php';

As I said in my comment, you can click on the little table icon to the left of the table name (assuming, as Mike B said, we are talking about the table list on the left) and it will open up the table structure page.

AFAIK, switching the behavior on those links is not possible through a configuration directive. You would have to dig through the code and change it in there. Shouldn't be too complicated, though.