(no subject)

[gwywnnydd]

What's the SQL syntax for the query :
Select Table_Name where (contains column_name)

:|
This would make my job easier today.

Comments

[burgunder.livejournal.com]

I don't have SQL in front of me, but I believe there are indeed meta tables that contain the info you're looking for (I've used Postgres, Oracle and MySQL, so I think it's available in those? It's been a loooong time...). Good luck!

[sistawendy.livejournal.com]

I know Microsoft SQL Server has metadata for this sort of thing, but I don't know exactly how to query it.

[kaneda-khan.livejournal.com]

select table_schema, table_name
from information_schema.columns
where column_name = 'whatever';

[gwywnnydd.livejournal.com]

You rock!

[kaneda-khan.livejournal.com]

<han-solo>I know.</han-solo>