SELECT 
    T01.[object_id]
   ,T01.[name]
   ,T01.[column_id]
   ,T01.[system_type_id]
   ,T01.[user_type_id]
   ,T01.[max_length]
   ,T01.[precision]
FROM
   [sys].[columns] T01