Get list of all table name along with their column name

The following MS SQL query can be used to get list of tables along with their column details.

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

Source : MSDN Forum