System Schema - List of all Tables/Columns/Data Types/Primary Key

SELECT *
FROM sys.tables t,
     sys.all_columns c,
     sys.types ty
WHERE t.object_id=c.object_id
  AND c.system_type_id=ty.system_type_id 
AND ty.name='uniqueidentifier'

----Below SQL will pull Primary Keys as well

SELECT c.name,
       ty.name,
       c.max_length,
       i.is_primary_key,
       *
FROM sys.all_objects ta
INNER JOIN sys.all_columns c ON c.object_id=ta.object_id
INNER JOIN sys.schemas s ON s.schema_id=ta.schema_id
INNER JOIN sys.types ty ON c.user_type_id=ty.user_type_id
LEFT OUTER JOIN sys.index_columns ic ON ic.object_id=c.object_id
AND ic.column_id=c.column_id
LEFT OUTER JOIN sys.indexes i ON i.object_id=c.object_id
AND ic.index_id=i.index_id