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 |
|
10Dawg
Starting Member
46 Posts |
 Posted - 2011-07-01 : 08:00:59
|
| I need to write a script for a daily recap report but I don't know in what tables, some of the information exists. Is there a command or script that shows what fields are populated and what table they are in?10Dawg |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-07-01 : 08:10:17
|
| This will give you all the columns and the tables they're inselect * from INFORMATION_SCHEMA.COLUMNSJimEveryday I learn something that somebody else already knew |
 |
|
|
|
|
|
Where's the data?