renatocfrancisco/datatypes.sql

Created August 4, 2022 17:55

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

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

Download ZIP

SQL Script to check datatypes in a table

Raw

datatypes.sql

	SELECT
	TABLE_NAME,
	COLUMN_NAME,
	DATA_TYPE
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE TABLE_NAME = 'table';

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment