Digging SCCM SQL Database : SCCM Database Tables and Columns

I have been always struggling to get desired data from SCCM and it's a really hard job. At least for me J Following query resolved my all problem of searching information SELECT * FROM INFORMATION_SCHEMA.Columns This gives you all SCCM sql tables information with their columns detail. Now you know what is where …. Cheers……