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 |
|
rarcher
Starting Member
2 Posts |
 Posted - 2010-06-22 : 22:51:05
|
| I'm just coming back to SQL Server after several years of being away, so I hope this question isn't too simple.We are converting a legacy app to a purchased SQL Server app and I will be the one transforming the data. I need a document/report/display that shows me the tables in the "to" database and lists the fields in each table, similar to what MS Access' Database Documentor does. If there isn't any such tool, what about a query that would get me close?R. Archer |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-06-22 : 22:53:00
|
query the INFORMATION_SCHEMA.COLUMNS
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
rarcher
Starting Member
2 Posts |
Posted - 2010-06-28 : 10:58:27
|
| Thanks! The results are a little messy, but managable, and certainly better than what I had.FYI to others, select "output to file" and then import into something more useful with Excel, Access, etc.R. Archer |
|
|
|
|
|
|
Database Documentor