[dba-SQLServer] All tables, columns and indexes

Arthur Fuller fuller.artful at gmail.com
Mon Aug 4 13:43:53 CDT 2008


I was building an Excel worksheet to list all the tables in my db in column
A, then the indexes for each table in column B, and the columns in each
index in Column C, because I couldn't figure out how to grab that data in a
single SELECT. Can you help? I can see portions here and there but I'm not
seeing how to grab it all in one grab.

Thanks,
Arthur



More information about the dba-SQLServer mailing list