cakephp - get table names and its column details

Question

Does anyone knows how to get table name from model name? Also I want to get all column names and its types of that model/table name. Is it possible to get such details of given model name?

Thanks.

Answer 1

Table Name

To get the table, see

$this->Model->table

Or check the model for the class variable $useTable. If that's undefined, then you can infer it from the name of the model:

$tableName = Inflector::tableize($this->Model->alias);

See the Inflector documentation for similarly useful methods.

Columns

Take a look at the schema method of the Model class. For example:

var_dump($this->Model->schema());