gautamlakum
gautamlakum

Reputation: 12035

cakephp - get table names and its column details

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.

Upvotes: 3

Views: 12924

Answers (1)

Ben Graham
Ben Graham

Reputation: 2099

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());

Upvotes: 9

Related Questions