Get long table name in Magento

Get full table name

Mage::getSingleton('core/resource')
    ->getTableName($tableShortName);

Example:

Mage::getSingleton('core/resource')
    ->getTableName('catalog/product');