OlegGorj/all tables and column types - sql server.md

Created October 12, 2018 14:45

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/OlegGorj/6fbf22e1d491546ad99fb589f42e8567.js"></script>
Save OlegGorj/6fbf22e1d491546ad99fb589f42e8567 to your computer and use it in GitHub Desktop.

Raw

all tables and column types - sql server.md

SELECT T.name AS Table_Name ,
       C.name AS Column_Name ,
       P.name AS Data_Type ,
       P.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
WHERE  T.type_desc = 'USER_TABLE';