How To Get Table Name in Magento..?

Get Table Name in Magento : You can easily add table in Magento by using the following code.

Suppose you need to get table name category_product.

Table Name in Magento : Syntax

$resource = Mage::getSingleton('core/resource');
$tableName=$connection->getTableName('catalog/product_index_price')

In Catalog module config.xml Magento define this table entity is product_index_price. So if you use table prefixes to get the name of the table you can use the above code to find the name of the table respectively.