The following are the available table template parameters.
Set delete_comments_on_drop template parameter for a database table to drop the descriptions when dropping a table. The default is true. Set this to false if you do not use the scema creation script to recreate the descriptions. This parameter applies when dropping a table, and can be set for the specific session. For example,
delete_comments_on_drop=true
Set allow_check_constraint_nulls template parameter for a database table to allow nulls for a column(s) with a check constraint. This parameter applies when using a table and cannot be set for the session. The default is true. For example,
allow_check_constraint_nulls=true
Set allow_references_constraint_nulls template parameter for a database table to allow nulls for referential constraints. This parameter applies when using a table and cannot be set for individual sessions. The default is true. For example,
allow_references_constraint_nulls=true
Set allow_unique_constraint_nulls template parameter for a database table to allow nulls for columns with unique constraints. This parameter applies when using a table and cannot be set for individual sessions. The default is true. For example,
allow_unique_constraint_nulls=true
Set this parameter for a database table to determine how many tuple locks in a transaction warrant an upgrade to a table-level lock. This parameter applies when using a table, and is not a session-level parameter. For example,
table.tuple_lock_threshold=1001
Set this parameter for a database table to setup locking such that only one update transaction can get a lock on the table index at a time. This is useful in avoiding deadlocks when there is a high degree of contention on updates to a table. This parameter applies when using a table, and is not a session-level parameter. The default value is true. For example,
insert_burst_optimized=true
Set this parameter for a database table to setup the maximum number of tuples returned by a changes call, i.e. a request for all changes froma specified time. This parameter applies when using a table, and is not a session-level parameter. The default value is 1000. For example,