same field name with different tables

gowridoc · #1 (**permalink**) 09-21-07, 02:06

m using EmpName filed in lot of tables in sql server data base.

how to write a query to find how many tables contains EmpName

thanks in advance

gowri

georgev · #2 (**permalink**) 09-21-07, 04:30

Take a look at the syscolumns table

r937 · #3 (**permalink**) 09-21-07, 08:23

gowri, please stop re-posting the same question!! especially in the wrong forums!!

see same filed with different table in sql server

and george, syscolumns is ~so~ last century

georgev · #4 (**permalink**) 09-21-07, 08:28

What's wrong with syscolumns?

r937 · #5 (**permalink**) 09-21-07, 08:34

doesn't work in sql server 2005

georgev · #6 (**permalink**) 09-21-07, 08:42

It works on the 2005 box I play on...

Anyhow, how come we're letting this thread stay? It's been posting at least 3 times already, and it's in the wrong place!

r937 · #7 (**permalink**) 09-21-07, 09:09

ah, well, then i guess i was misinformed

still, it's always better to use the features that were intended for that purpose, especially if they are standard sql, n'est-ce pas?

Quote:

Originally Posted by daManual

Information schema views are based on catalog view definitions in the SQL-92 standard. They present the catalog information in a format that is independent of any catalog table implementation and therefore are not affected by changes in the underlying catalog tables. Applications that use these views are portable between heterogeneous SQL-92 compliant database systems.