How to Add a Comment to a Table in Snowflake

Last updated July 24, 2026 · By the SaturnSQL team

Use COMMENT ON TABLE (or COLUMN) to attach documentation that shows up in SHOW TABLES, DESCRIBE, and most catalog tools. Comments can also be set inline in CREATE TABLE.

COMMENT ON TABLE orders IS 'One row per customer order, updated hourly';
COMMENT ON COLUMN orders.amount IS 'Order total in EUR incl. VAT';

SELECT table_name, comment
FROM analytics.information_schema.tables
WHERE comment IS NOT NULL;