Snowflake情報スキーマの使用

SELECT table_name, table_type

FROM kent_db.information_schema.tables

WHERE table_schema = 'PUBLIC'

ORDER BY 1;

SELECT 'Comment on table.'||table_name||' is '''||nvl(tables.comment||'''', 'No Comment Recorded''')

FROM kent_db.information_schema.tables tables

WHERE table_schema = 'PUBLIC';

SELECT table_name, constraint_type, constraint_name

FROM sales.information_schema.table_constraints

WHERE constraint_schema = 'TPC_DV_OPT'

ORDER BY table_name;

SELECT 'drop table '||table_name||' cascade;'

FROM kent_db.information_schema.tables tables

WHERE table_schema = 'PUBLIC'

ORDER BY 1;