Find Table definition SQL

 SELECT

COLUMN_NAME, DATA_TYPE,character_maximum_length 

FROM INFORMATION_SCHEMA.COLUMNS 

WHERE 

TABLE_SCHEMA = 'dbo' AND  TABLE_NAME = 'Table name' 

-----------------------------------------------------

SELECT

    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'Table' AND is_identity != 1