Computing.Net > Forums > Database > find column name across tables

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

find column name across tables

Reply to Message Icon

Name: jds
Date: March 20, 2008 at 10:37:48 Pacific
OS: sql sever 2003
CPU/Ram: 2gb
Product: xp
Comment:

Hi
I am new in SQL server.
I am trying to find out which tables contain a specific column name in entire database.
Is there any equivalent dictionary as is in Oracle?
Thank you very much



Sponsored Link
Ads by Google

Response Number 1
Name: jds
Date: March 25, 2008 at 09:33:57 Pacific
Reply:

Thank you and I got the answer
Select *
From INFORMATION_SCHEMA.COLUMNS
Where column_name = '{comlumn name}'


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: find column name across tables

Oracle Column Data Convertion www.computing.net/answers/dbase/oracle-column-data-convertion/306.html

my_SQL, Permissions Question www.computing.net/answers/dbase/mysql-permissions-question/312.html

SQL compact multiple row update www.computing.net/answers/dbase/sql-compact-multiple-row-update/189.html