Skip to content

Instantly share code, notes, and snippets.

@realdubb

realdubb/mssql-tips.md

Created October 17, 2017 20:53
Show Gist options
  • Save realdubb/10676a71ee9665c62b9f1c6b0093bc1c to your computer and use it in GitHub Desktop.
Save realdubb/10676a71ee9665c62b9f1c6b0093bc1c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mssql-tips.md

How do I get the data type of each field from a table?

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = 'Table-Name'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment