Skip to content

Instantly share code, notes, and snippets.

@thorsman99

thorsman99/Tbl&ColList.sql

Created November 16, 2017 16:43
Show Gist options
  • Save thorsman99/6b38fc7cd817934ee94984c8275c5a34 to your computer and use it in GitHub Desktop.
Save thorsman99/6b38fc7cd817934ee94984c8275c5a34 to your computer and use it in GitHub Desktop.
Download ZIP
List sql tables and columns #sql
Raw
Tbl&ColList.sql
SELECT db_name() as DATABASE_NAME, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION,
COLUMN_DEFAULT, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH,
NUMERIC_PRECISION, NUMERIC_PRECISION_RADIX, NUMERIC_SCALE,
DATETIME_PRECISION
FROM INFORMATION_SCHEMA.COLUMNS
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment