Skip to content

Instantly share code, notes, and snippets.

@spy86

spy86/ColumnList.sql

Created November 23, 2021 20:00
Show Gist options
  • Save spy86/4fd5259095e74105784203e5824ef403 to your computer and use it in GitHub Desktop.
Save spy86/4fd5259095e74105784203e5824ef403 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ColumnList.sql
SELECT table_schema
,table_name
,column_name
,data_type
,character_maximum_length
,numeric_precision
,column_default
FROM information_schema.columns
WHERE table_name = 't1'
ORDER BY table_name
,ordinal_position;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment