Database property sheet: Settings tab

Database properties listed on this tab cannot be changed without rebuilding the database.

For information about rebuilding a database, see Rebuilding databases.

The Settings tab of the Database property sheet has the following components:

Encryption type Shows whether or not the database is encrypted, and the type of encryption: Simple, AES, or MDSR. If encryption is not supported in the database, None appears.

For information about the types of encryption supported by Adaptive Server Anywhere, see Encrypting a database.
Case sensitive Shows whether or not the database is case sensitive. This property applies to the data in the database, and to passwords, but not to table names, column names, and other identifiers.
Ignore trailing blanks Shows whether the database ignores trailing blanks in comparisons.
Default collation Shows the default collation of the database.
Checkpoint urgency Shows the time that has elapsed since the last checkpoint as a percentage of the checkpoint time setting of the database. Click Refresh or press F5 to update the Checkpoint urgency value.
Recovery urgency Shows an estimate of the amount of time required to recover the database. Click Refresh or press F5 to update the Recovery urgency value.
Refresh Click Refresh to update the checkpoint urgency and recovery urgency values.
Database Capabilities Lists database capabilities. A green checkmark appears beside the capabilities that are enabled for the database. A red X appears beside capabilities that are not enabled for the database.