Same field names in all tables 1

[iamtrying]

Hi,

I am working with a large SQl server 2000 database which has lots of tables. Is there an SQL statement which will return all the tables with a specific column(field) name? For example, show all tables with the field name call_time.

Thanks

 

[gmmastros]

Select Table_Name 
From   Information_Schema.COlumns
Where  Column_Name = 'call_time'

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[iamtrying]

gmmastros

Thanks for responding. This is going to save me a lot of time when writing Crystal Reports! Perfect!!