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