Skip to content

Instantly share code, notes, and snippets.

@Lkledu

Lkledu/tableInfo.sql

Created July 30, 2019 12:25
Show Gist options
  • Save Lkledu/9b5f45f918d86347487edd1a9bee9245 to your computer and use it in GitHub Desktop.
Save Lkledu/9b5f45f918d86347487edd1a9bee9245 to your computer and use it in GitHub Desktop.
Download ZIP
Select table info <SQL Server>
Raw
tableInfo.sql
SELECT COLUMN_NAME,DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'insert_table_name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment