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 |
|
divyaram
Posting Yak Master
180 Posts |
 Posted - 2012-03-08 : 06:46:50
|
| Hi All,I have Different DB's( there are around 100 DB's). i would like to get all tabletable and corresponding column_name from these 100 Db's.How will i get these details .Thanks in advance ,DivyaRegards,Divya |
|
|
divyaram
Posting Yak Master
180 Posts |
Posted - 2012-03-08 : 07:44:40
|
| Anyone help me on this :(Regards,Divya |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2012-03-08 : 08:29:15
|
| information_schema.columns and msforeachdb comes to mind...http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-08 : 10:22:02
|
quote:
Originally posted by divyaram
Hi All,I have Different DB's( there are around 100 DB's). i would like to get all tabletable and corresponding column_name from these 100 Db's.How will i get these details .Thanks in advance ,DivyaRegards,Divya
are all these 100 DBs in same server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Column Name's of all table from different DB