SQL - Retrieving field type

[Dudsmack]

Using SQL querries how can I get the field type of a particular field?

[NogDog]

Simplest way:

DESCRIBE table_name;

[Dudsmack]

Thanks.

Is there any way to retrieve just the field type when i know the table name and the field name?

[chazzy]

it depends on your database.

which one are you using?

[Dudsmack]

mysql

[NogDog]

DESCRIBE table_name column_name;