bs28666

Query All The Tables (metadata)

Discussion created by bs28666 on Mar 1, 2019
Latest reply on May 21, 2019 by Steve Bailey
select table_schema, table_name, column_name, comment, is_nullable, data_type, is_identity
from information_schema.columns
where table_schema != 'information_schema'
order by table_schema, table_name, ordinal_position;

 

This query will give you a list of all columns in the database and comments (if available).

Outcomes