![]() |
Publications
|
|
Altering Published TablesThe ALTER TABLE command allows you to add a column to a table, add a constraint, or drop a constraint. You can use ALTER TABLE even if the table has already been published. If ALTER TABLE adds a column, and if the column's table was published without a column list, the column automatically appears in the publication. If the table was published with a column list, you will have to drop and re-add the table to the publication using ALTER PUBLICATION if you want to include the new column in the publication. If ALTER TABLE adds a unique or check constraint, and if all columns mentioned in the constraint are in the publication, the constraint is automatically added to the publication. If ALTER TABLE drops a unique or check constraint (other than a primary key) that is implicitly published, that constraint is removed from the publication. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |