csabafarkas/get_all_non_null_columns.sql

Created January 19, 2017 17:34

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

Download ZIP

Raw

get_all_non_null_columns.sql

	SELECT
	TABLE_NAME, COLUMN_NAME, IS_NULLABLE
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE IS_NULLABLE = 'NO'

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