How to get database field type in Laravel?

Question

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.

Answer 1

For Laravel 4:

After digging in Laravel, this is what I got.

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

Answer 2

For Laravel 5.2 - 9.x

use Illuminate\Database\Schema\Builder::getColumnType()

DB::getSchemaBuilder()->getColumnType($tableName, $colName) 

e.g.

$ageType = DB::getSchemaBuilder()->getColumnType('user', 'age') 

You may need to run this command if you haven't already:

composer require doctrine/dbal