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 |
|
ashtu
Starting Member
10 Posts |
 Posted - 2008-04-20 : 08:51:37
|
| HiI need to find the tables in which a particular column exists in the database. Please provide me an appropriate query.your answer is.......select table_name,column_name from information_schema.columns where column_name like '%bill%'and i have done from my database select ActionMaster,ActionName from information_schema.columns where ActionName like '%Test%'then ERROR Like thatMsg 207, Level 16, State 1, Line 1Invalid column name 'ActionName'.Msg 207, Level 16, State 1, Line 1Invalid column name 'ActionMaster'.Msg 207, Level 16, State 1, Line 1Invalid column name 'ActionName'give the right solution........Ashish |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-20 : 13:34:56
|
| select tablename,columnname from information_schema.columns where columnname like '%bill%'have a look at catalog views to get moore info on table columns:-http://developer.mimer.com/documentation/html_91/Mimer_SQL_Engine_DocSet/Data_dic_views2.html#1167517 |
 |
|
|
|
|
|
I con' undestand infomation_schema.column