Use "sys.dm_exec_describe_first_result_set" to return information about a SQL Stored Procedure result set. Including column name, type, size, coalition, and more.

select * from sys.dm_exec_describe_first_result_set('<schema>.<sp_name>', null, 0);