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.

joshua.paling · Accepted Answer · 2013-05-23 04:23:01Z

9

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

edited May 23, 2013 at 4:23

joshua.paling

14k4 gold badges47 silver badges61 bronze badges

answered Oct 10, 2011 at 8:04

Ben Graham

2,11917 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dave Over a year ago

I think for table name, you can just use $this->Model->table

Ben Graham Over a year ago

So you can! nice :) Included in answer, left Inflector stuff in because it's still handy to know

petrica.martinescu Over a year ago

In order to include the table prefix ready to be used for a raw query you will have to call the dbo source model: $this->getDataSource()->fullTableName($this)

Collectives™ on Stack Overflow

cakephp - get table names and its column details

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related