Get List of all Tables names and their respective Columns names in SQL Server Database

SQL SERVER 2000

--SQL SERVER 2000
USE [Northwind]
GO

SELECT sysobjects.name [TableName], sys.columns.name [ColumnName] FROM sysobjects
INNER JOIN sys.columns  ON sysobjects.id = sys.columns.object_id
WHERE xtype='U' 
GROUP BY sysobjects.name, sys.columns.name

SQL SERVER 2005, 2008, 2012

--SQL SERVER 2005+
USE NorthWind
GO

SELECT sys.tables.name [TableName], sys.columns.name [ColumnName] FROM sys.tables
INNER JOIN sys.columns  ON sys.tables.object_id = sys.columns.object_id
GROUP BY sys.tables.name, sys.columns.name