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
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