find column name across tables - Computing.Net

Specialty Forums
Security and Virus
General Hardware
CPUs/Overclocking
Networking
Digital Photo/Video
Office Software
PC Gaming
Console Gaming
Programming
Database
Web Development
Digital Home

General Forums
Windows XP
Windows Vista
Windows 95/98
Windows Me
Windows NT
Windows 2000
Win Server 2008
Win Server 2003
Windows 3.1
Linux
PDAs
BeOS
Novell Netware
OpenVMS
Solaris
Disk Op. System
Unix
Mac
OS/2

Drivers
Driver Scan
Driver Forum

Software
Automatic Updates

BIOS Updates

My Computing.Net

Solution Center

Free IT eBook

Howtos

Site Search

Message Find

RSS Feeds

Install Guides

Data Recovery

About

Home

find column name across tables

Original Message

Name: jds
Date: March 20, 2008 at 10:37:48 Pacific
Subject: find column name across tables
OS: sql sever 2003
CPU/Ram: 2gb
Model/Manufacturer: 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

Report Offensive Message For Removal

Response Number 1

Name: jds
Date: March 25, 2008 at 09:33:57 Pacific
Subject: find column name across tables

Reply: (edit)

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

Report Offensive Follow Up For Removal


SQL compact multiple row update textbox control source Oracle Column Data Convertion my_SQL, Permissions Question Need SQL Query	Oracle spool output to file Ms Access records Access 2000 query result SQL Question about DISTINCT ACCESS Record Merge

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: find column name across tables

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

Data Recovery Software

exessive internet traffic

ZoneAlarm Question. Blocked Connect

Windows Live Messenger Problem

Delete $Uninstall after SP3 updates

help for hp compaq laptop

The information on Computing.Net is the opinions of its users. Such opinions may not be accurate and they are to be used at your own risk. Computing.Net cannot verify the validity of the statements made on this site. Computing.Net and Computing.Net, LLC hereby disclaim all responsibility and liability for the content of Computing.Net and its accuracy.
PLEASE READ THE FULL DISCLAIMER AND LEGAL TERMS BY CLICKING HERE

All content ©1996-2007 Computing.Net, LLC