Thread: sql query to get field types

sql query to get field types

From
Alexander Cohen
Date:
What sql query can i use to get all relative data to the types of
fields that a table contains?


--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(819) 432-3443


Re: sql query to get field types

From
"scott.marlowe"
Date:
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