henrytran9x/query.sql

Created September 30, 2017 16:18

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/henrytran9x/2af188e47fc754e2ce89ab81a245cc70.js"></script>
Save henrytran9x/2af188e47fc754e2ce89ab81a245cc70 to your computer and use it in GitHub Desktop.

Download ZIP

Query get all information columns of table

Raw

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment