indraginanjar Dec 13th, 2018 83 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select table_schema,
  2.     table_name,
  3.     column_name,
  4.     column_type,
  5.     is_nullable,
  6.     column_comment
  7. from information_schema.columns
  8. where table_schema = '<database/schema name>'
  9. order by table_schema, table_name, ordinal_position
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand