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

Created October 12, 2018 14:44

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/f0e1c28f783be2cca87d219182e14473.js"></script>
Save OlegGorj/f0e1c28f783be2cca87d219182e14473 to your computer and use it in GitHub Desktop.

Raw

select all tables and column types - sql server.md

SELECT TABLE_SCHEMA , TABLE_NAME , COLUMN_NAME , ORDINAL_POSITION , COLUMN_DEFAULT , DATA_TYPE , CHARACTER_MAXIMUM_LENGTH , NUMERIC_PRECISION , NUMERIC_PRECISION_RADIX , NUMERIC_SCALE , DATETIME_PRECISION FROM INFORMATION_SCHEMA.COLUMNS;