SELECT DISTINCT
        TABLE_NAME,
        COLUMN_NAME
FROM    ( SELECT    TABLE_NAME,
                    COLUMN_NAME = REPLACE(( SELECT  '[' + hp.COLUMN_NAME + ']' AS [data()]
                                            FROM    INFORMATION_SCHEMA.COLUMNS hp
                                            WHERE   hp.TABLE_NAME = T.TABLE_NAME
                                            ORDER BY hp.ORDINAL_POSITION
                                          FOR
                                            XML PATH('')
                                          ), ' ', ',')
          FROM      INFORMATION_SCHEMA.COLUMNS T
          WHERE     TABLE_NAME NOT IN ( SELECT  TABLE_NAME
                                        FROM    INFORMATION_SCHEMA.VIEWS )
        ) T
ORDER BY TABLE_NAME DESC