Re: Getting all tables which contains a specific column name

Ok I got it already.

SELECT table_name
FROM information_schema.columns
WHERE column_name = 'is_active'
ORDER BY ordinal_position;

I don't know if this is correct. Please correct me if I'm wrong.

Thanks,

Ridvan
On Wed, Apr 22, 2009 at 2:45 PM, Ridvan Lakas ng Bayan S. Baluyos <
ridvan(at)baluyos(dot)net> wrote:

> Hi list,
>
> How do I get all the tables which contains a specific column name? For
> example, I want to get all tables that has an `is_active` column in them?
>
>
> Thanks,
>
> Ridvan
>
> --
> リヅバン バルヨス
> ridvan(dot)baluyos(at)qualservcentral(dot)com
> http://ridvan.baluyos.net
> http://www.onxiam.com/people/rbaluyos
>
> Registered Linux User #439466
> Registered Ubuntu User #16034
> Q: Have you heard of the Object-Oriented way to get wealthy?
> A: Inheritance.
>

--
リヅバン バルヨス
ridvan(dot)baluyos(at)qualservcentral(dot)com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos

Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.