SQL Question: Describe <tablename>;

From: Bigus Dickus <no_spam_for_me_thanks_at_yahoo.com>
Date: Fri, 28 Mar 2003 06:51:29 -0800
Message-ID: <3E846171.65F3E372_at_yahoo.com>

[Quoted] I am looking for a way to select all fields of a particular type from a table.

E.g.

select * from my_table where Type = CHAR(10);

or something _like_ that.

describe doesn't seem to allow a complex query.

E.g.

describe my_table where Type = CHAR(10);

doesn't work. Received on Fri Mar 28 2003 - 15:51:29 CET