Skip to content

Instantly share code, notes, and snippets.

@felixlindemann

felixlindemann/getColumns.sql

Created September 9, 2013 09:10
Show Gist options
  • Save felixlindemann/6493275 to your computer and use it in GitHub Desktop.
Save felixlindemann/6493275 to your computer and use it in GitHub Desktop.
Download ZIP
Get All Columns from a table as Query.
Raw
getColumns.sql
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA='TABLE_SCHEMA'
AND TABLE_NAME='TABLE_NAME';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment