Get a list of Field Names and Data Types for a MSSQL table

Use this type of SQL to generate a listing of field names and properties for an MSSQL table

USE //Your Database Name//
SELECT 
     c.object_id 
     , c.column_id , c.name , types.name 
     , c.[max_length] 
     , c.[precision] 
     , c.[scale] 
   FROM  sys.all_columns c 
     JOIN sys.tables t ON c.object_id = t.object_id
     JOIN sys.types types ON c.user_type_id = types.user_type_id
WHERE t.name = '//Your Table Name//'