Find Table definition SQL Server

 There is few way to get the table information like below.

1. 

Sp_help 'TableName' 

2. 

SELECT
COLUMN_NAME, DATA_TYPE,character_maximum_length
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE 
TABLE_SCHEMA = 'dbo' AND  TABLE_NAME = 'TableName' 

Convert Rows to Comma Seperated Column 

DECLARE @Names VARCHAR(MAX) = '';
SELECT
    --COALESCE(clmns.name , ',')
	@Names = COALESCE(@Names + ', ', '') + clmns.name 
    FROM
    sys.tables AS tbl
    INNER JOIN sys.all_columns AS clmns ON clmns.object_id=tbl.object_id
    LEFT OUTER JOIN sys.indexes AS ik ON ik.object_id = clmns.object_id and 1=ik.is_primary_key
	LEFT OUTER JOIN sys.index_columns AS cik ON cik.index_id = ik.index_id 
    and cik.column_id = clmns.column_id 
    and cik.object_id = clmns.object_id and 0 = cik.is_included_column
 where tbl.name = N'DCEMI_TBL_HDFC_PDF_Sign_ReqResp_Logs'-- AND is_identity != 1
 SELECT @Names;