Re: sql query to get field types

On Mon, 1 Mar 2004, Alexander Cohen wrote:

> What sql query can i use to get all relative data to the types of
> fields that a table contains?

select column_name,data_type from information_schema.columns where
table_name='test';

works in 7.4