Specialized columns

You can create specialized columns to support Enterprise Replication, high availability, or row-level auditing.

Read syntax diagramSkip visual syntax diagram
Specialized columns

     .-WITH--+-AUDIT-----+-.     
     |       +-CRCOLS----+ |     
     |       +-ERKEY-----+ |     
   .-|       +-REPLCHECK-+ |-.   
   V |       '-VERCOLS---' | |   
|----+---------------------+-+----------------------------------|

There is no required order among multiple WITH options in the same CREATE TABLE statement.

Important: You cannot use the WITH clause of the CREATE TABLE statement to add a new shadow column or to make any other changes to the schema of a table that already exists. To change, for example, any of the WITH keyword options that are included or omitted when an existing table was created, use the appropriate option of the ALTER TABLE ADD or the ALTER TABLE DROP statement. For more information, see ALTER TABLE statement.

Copyright© 2019 HCL Technologies Limited