Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

list of all columns in a database

0 views
Skip to first unread message

wei

unread,
Jul 9, 2007, 3:49:57 PM7/9/07
to
Is there a way to list all the columns in a MySQL db, so that I can
find the tables which has a specific column name?

For example, find all tables which contain a "account_id" column.

I know Oracle has system tables contain such information, does MySQL
has similar stuff?

Thanks,

Wei

wei

unread,
Jul 9, 2007, 3:53:23 PM7/9/07
to

Never mind, I found the COLUMNS table in the information_schema

0 new messages