How to find all tables with a specific column name in MS SQL

Simple and effective:

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE COLUMN_NAME LIKE 'INVOICE%'

215c6b11-45a5-4a8f-8758-8ad9f1088034|0|.0

Categories: Databases | SQL

Posted by wizgod on Tuesday, September 28, 2010 9:23 PM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (2) | Post RSS RSS comment feed

How to find all tables with a specific column name in OracleSimple and effective: SELECT TABLE_NAME FROM USER_TAB_COLUMNS WHERE COLUMN_NAME='PARTNO' Dovecot/Postfix problems with relaying, recieving and sending emails on an internal networkWell, I setup a linux vm at work running Ubuntu with a static ip and an internal domain (devteam.grp...MS SQL TOP equivelant in OracleOriginal Post: http://bytes.com/topic/oracle/answers/631642-top-10-rows#post2501910 For top row ju...

Comments