Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.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 that 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 that 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 is 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 that 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. It cannot be modified after the table is created. | off | off exact

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

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