Navigation

4Guys
ASP.NET
Home
dasBlog

Search

Categories

 
 
 
 
 
 
 
 
 
 
 
 
 
 

On this page

Archive

July, 2008 (4)
June, 2008 (3)
May, 2008 (8)
April, 2008 (21)
March, 2008 (4)
February, 2008 (2)
January, 2008 (8)
December, 2007 (8)
November, 2007 (11)
October, 2007 (5)
September, 2007 (1)
August, 2007 (1)
July, 2007 (11)
June, 2007 (24)

Blogroll

 Tim Mackey

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

RSS 2.0 | Atom 1.0 | CDF

Send mail to the author(s) E-mail

Total Posts: 112
This Year: 50
This Month: 4
This Week: 0
Comments: 0

Sign In

 Tuesday, November 13, 2007
Finding a column name in SQL Server
Tuesday, November 13, 2007 12:21:03 PM (Eastern Standard Time, UTC-05:00) (  |  )

Use this to find out where a given field name or column reside and is being used in SQL Server.

select so.name
from sysobjects so inner join syscolumns sc
ON so.id = sc.id where sc.name = 'YourColumnNameGoesHere'

or

select so.name, sc.name
from sysobjects so inner join syscolumns sc
ON so.id = sc.id where sc.name like '%YourPartialColumnNameGoesHere%'

or

Select table_name from information_Schema.columns where column_name='yourCol'

 

Comments [0] | Trackback | # 
Related posts:
Common Solutions for T-SQL Problems
Getting column information using T-SQL
Getting a Record Count
SqlConnection.RetrieveStatistics()
How to Share Data Between Stored Procedures
Connection String has not been properly iniitialized
Name
E-mail
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):