SELECT QUOTENAME(SCHEMA_NAME(tb.[schema_id])) AS 'Schema'
	,QUOTENAME(OBJECT_NAME(tb.[OBJECT_ID])) AS 'Table'
	,C.NAME as 'Column'
	,T.name AS 'Type'
	,C.max_length
	,C.is_nullable
FROM SYS.COLUMNS C INNER JOIN SYS.TABLES tb ON tb.[object_id] = C.[object_id]
	INNER JOIN SYS.TYPES T ON C.system_type_id = T.user_type_id
WHERE tb.[is_ms_shipped] = 0
ORDER BY tb.[Name]

TableName	ColumnName	Name	Length
Address	AddressID	int	4
Address	AddressLine1	nvarchar	120
Address	AddressLine1	AccountNumber	120
Address	AddressLine1	Name	120
Address	AddressLine1	OrderNumber	120
Address	AddressLine1	Phone	120
Address	AddressLine2	nvarchar	120
Address	AddressLine2	AccountNumber	120
Address	AddressLine2	Name	120
Address	AddressLine2	OrderNumber	120
Address	AddressLine2	Phone	120

SELECT table_schema, table_name, column_name, data_type, character_maximum_length,
    is_nullable, column_default, numeric_precision, numeric_scale
  FROM information_schema.columns
  ORDER BY table_schema, table_name, ordinal_position