Show TOC

Additional Options in Table CreationLocate this document in the navigation structure

Replication Server allows you to add additional options to all the create table commands sent from Replication Server to the SAP HANA database.

You can add additional options for your SAP HANA schema through the new configuration parameter create_table_append_text by using the alter connection command. After configuration, the configuration value is appended to the end of the create table command during materialization for initializing replicate tables and continuous replication.

Syntax
alter connection to <rds>.<rdb>
for replicate schema named <to_schema>
set <param> to '<value>'
Parameters
rds.rdb
Name of the replicate data server and database.
to_schema
The schema of the replicate database.
param
Currently, only create_table_append_text is supported. After configuration, the value of this configuration is appended to all the create table commands sent to the connected SAP HANA database.
value
The additional options to the create table command. Only the group_option and the location_clause syntax elements are supported to be added as additional options. To remove the additional options, set the value to a string with zero length.