mfrata/get_columns_names.sql

Created May 28, 2018 17:29

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

Download ZIP

Table columns names and data type

Raw

get_columns_names.sql

	SELECT column_name, data_type
	FROM information_schema.columns
	WHERE table_schema = 'your_schema'
	AND table_name = 'your_table'

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