Get Db Schema

gistfile1.txt

SELECT db_name() AS db_name,
       S.name AS Schema_Name,
       T.name AS Table_Name ,
       C.name AS Column_Name ,
       P.name AS Data_Type ,
       C.max_length AS Size ,
       CAST(P.precision AS VARCHAR) + '/' + CAST(P.scale AS VARCHAR) AS Precision_Scale
FROM   sys.objects AS T
           JOIN sys.columns AS C ON T.object_id = C.object_id
           JOIN sys.types AS P ON C.system_type_id = P.system_type_id
           INNER JOIN sys.schemas AS S ON S.schema_id = t.schema_id
WHERE  T.type_desc = 'USER_TABLE';