Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# Table Create Configuration Options

The command to create a table using tibdg has the following format:

    tibdg table create [option=value]... table-name column-name column-type [column-name column-type] ...

The following configuration options can be used with the `tibdg table create` command:

Option | Description | Default Value | Valid Value
--- | --- | --- | ---
`default_ttl` | Defines the number of seconds a row exists in a table before it is automatically removed from the table. A value of 0 seconds means the row is never automatically removed from the table. | 0 | Minimum 0
`expiration_scan_period` | Defines how often, in seconds, the data grid should scan for rows which have surpassed their `default_ttl` setting. | 3600 | Minimum 1
`full_table_delete` | Defines the behavior when a SQL DELETE statement is created which does not contain a WHERE clause. Overrides the grid's full_table_delete setting for all tables. Execution of a SQL DELETE statement without a WHERE clause deletes all rows of a table. This option takes one of the following values: inherited (default): The grid's full_table_delete setting will be applied to the table. enabled: A debug message is logged by the proxy when a SQL DELETE statement without a WHERE clause is created. All rows of the table are allowed to be deleted. disabled: Prevents creation of SQL DELETE statements which do not contain a WHERE clause. warn: A warning is logged by the proxy when a SQL DELETE statement without a WHERE clause is created. All rows of the table are allowed to be deleted. Note: The `full_table_scans=disabled` option prevents the execution of a SQL DELETE statement without a WHERE clause regardless of the setting for `full_table_delete`. The option also prevents the execution of a SQL DELETE statement with a WHERE clause when an index cannot be found for the columns in the WHERE clause. | inherited | inherited enabled disabled warn
row_counts | Enables statistics for a table. Cannot be modified after the table is created. | off | off exact

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.