Skip to content

Instantly share code, notes, and snippets.

@AllanLRH

AllanLRH/get_sql_schema_information.sql

Created April 1, 2020 13:41
Show Gist options
  • Save AllanLRH/48da93ba882dfc6c2f010e7dee1b8a77 to your computer and use it in GitHub Desktop.
Save AllanLRH/48da93ba882dfc6c2f010e7dee1b8a77 to your computer and use it in GitHub Desktop.
Download ZIP
Get SQL scheme information for table
Raw
get_sql_schema_information.sql
SELECT COLUMN_NAME
,IS_NULLABLE
,DATA_TYPE
,CHARACTER_MAXIMUM_LENGTH
,NUMERIC_PRECISION
,DATETIME_PRECISION
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TABLE_NAME'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment