Issue

Is there a way to get the datatype of a database table field? This would be almost like the inverse of a migration.

For example, if the migration of a users table column looks like

...
$table->integer('age')
...

Is there a function that will return integer if I specify table user and column age?

I'm not interested in a specific database implementation, (mysql_field_type()). Like Laravel's migration, it needs to be database agnostic.

Solution

For Laravel 4:

After digging in Laravel, this is what I got.

DB::connection()->getDoctrineColumn('users', 'age')->getType()->getName()

Answered By - Hao Luo