Usage
Modifies the definition of an existing sending or receiving table. Except for the table's name and location, you can redefine any of the attributes of the existing definition, including the table's columns, and protected status.
ALTER SHARED TABLE database-name.schema-name.table-name
AT [ SERVER | SERVERS ] server-name, ...
TO
[ NOT PROTECTED| PROTECTED [ BY shadow-table-name ]{ COLUMNS ( column-name , ... )|ALL COLUMNS }
;The clauses in the ALTER SHARED TABLE statement after the initial TO are exactly the same as those in the CREATE SHARED TABLE statement. See Create a shared table. You must re-specify the parts of the existing shared table definition that you want to retain, and substitute your altered options where appropriate. Statement options you do not explicitly specify in the ALTER SHARED TABLE statement do not default to the existing server definition; their default, if any, is as stated in the parameter definition.