Skip to content

Instantly share code, notes, and snippets.

@henrytran9x

henrytran9x/query.sql

Created September 30, 2017 16:18
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save henrytran9x/2af188e47fc754e2ce89ab81a245cc70 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save henrytran9x/2af188e47fc754e2ce89ab81a245cc70 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. henrytran9x created this gist Sep 30, 2017.
    1 change: 1 addition & 0 deletions query.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    SELECT column_name, data_type, character_maximum_length, numeric_precision, numeric_scale, is_nullable, column_type, column_default, column_key, extra FROM information_schema.columns WHERE table_name = 'table_name' AND table_schema = 'name_database' ORDER BY ordinal_position