Declare @TABLE_NAME SYSNAME='tbl_BWarehouse'

select t.TABLE_NAME,
		c.Column_Name,
		c.Data_Type,
		c.Numeric_Precision,
		c.Numeric_Scale,
		Isnull(Character_Maximum_Length,0) as Size
From INFORMATION_SCHEMA.TABLES as t
Inner join INFORMATION_SCHEMA.COLUMNS c ON
		(t.TABLE_NAME=c.TABLE_NAME)
Where t.TABLE_NAME=@TABLE_NAME
order by t.TABLE_NAME