T-SQL get alll columns name and column type from table

Select. name, Case. precision when 0 then case. is_ansi_padded when 1 then convert (nvarchar (15), B. name + '(' + convert (nvarchar (10),. max_length) + ') When 0 then B. name end else case. scale when 0 then B. name else B. name + '(' + convert (nvarchar (10),. precision) + ',' + convert (nvarchar (10),. scale) + ') 'endend as typelength from sys. columns A left join sys. types B on. system_type_id = B. system_type_id and. user_type_id = B. user_type_id where. object_id = (select object_id from sys. objects where name = 'address ')