Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AlexP
Starting Member
34 Posts |
 Posted - 2005-09-02 : 11:05:12
|
| Is there a script out there that I can use to search all the Column names in all tables for a particular database? I want to be able to look for a column name in a search like 'Mem%' and it to find me all the tables that contain the Column name 'Mem' like 'MemberId' etc...thanks |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-02 : 11:09:38
|
| Select table_name from information_Schema.columns where column_name like 'Mem%'MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Finding Column Names in a DB?