Hey guys, Nevermind Iíve able to write a select and join sys.object with sys.columns and accomplished what I needed. For reference here is my code.
obj.name as TableName,
col.name as ColumnName,
obj.create_date as ColumnCreationDate,
obj.modify_date as LastModifiedDate
from ?.sys.objects obj
inner join ?.sys.columns col
on obj.object_id = col.object_id
where type_desc = ''USER_TABLE'' '