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