Skip to main content

UPDATE SHARE

Currently, sharing a database only creates a point-in-time snapshot of the database. To update the database to a newer version, you need to explicitly execute the UPDATE SHARE statement. All users of the share will automatically see data related changes (like inserts and updates) within 1 minute. Changes from ALTER TABLE statements will also be reflected automatically. Users will see all other catalog related changes (from things like CREATE TABLE/VIEW/SCHEMA statements), in addition to data related changes, upon new connections (native) or page reload (web).

Syntax

UPDATE SHARE <share name>;