Valentina Database Properties

On this page you can see list of system Valentina Database properties. You can get the list of properties using SHOW PROPERTIES command.

Read-write system property. Operate with UCOL_ALTERNATE_HANDLING object value.

GET PROPERTY AlternateHandling of database;
SET PROPERTY AlternateHandling of database to 'kDefault';

Read-write system property. Operate with UCOL_CASE_FIRST object value.

GET PROPERTY CaseFirst of database;
SET PROPERTY CaseFirst of database to 'kDefault';

Read-write system property. Operate with UCOL_CASE_LEVEL object value.

GET PROPERTY CaseLevel of database;
SET PROPERTY CaseLevel of database to 'kDefault';

Read-write system property. Operate with UCOL_FRENCH_COLLATION object value.

GET PROPERTY FrenchCollation of database;
SET PROPERTY FrenchCollation of database to 'kDefault';

Read-write system property. Operate with UCOL_HIRAGANA_QUATERNARY_MODE object value.

GET PROPERTY HiraganaQuaternaryMode of database;
SET PROPERTY HiraganaQuaternaryMode of database to 'kDefault';

Read-write system property. Operate with IO_Encoding object value. It is temporary property (not stored to the schema).

GET PROPERTY IOEncoding of database;
SET PROPERTY IOEncoding of database to 'UTF-16';

Read-write system property. Operate with LocaleName object value.

GET PROPERTY LocaleName of database;
SET PROPERTY LocaleName of database to 'en_US';

Read-write system property. Operate with UCOL_NORMALIZATION_MODE object value.

GET PROPERTY NormalizationMode of database;
SET PROPERTY NormalizationMode of database to 'kDefault';

Read-write system property. Operate with UCOL_NUMERIC_COLLATION object value.

GET PROPERTY NumericCollation of database;
SET PROPERTY NumericCollation of database to 'kDefault';

Read-write system property. Operate with UCOL_STRENGTH object value.

GET PROPERTY Strength of database;
SET PROPERTY Strength of database to 'kDefault';

Read-only system property. Return 1 if object is encrypted and 0 otherwise.

GET PROPERTY Encrypted of database;

Read-only system property. Return 1 if object is a root of encrypted objects tree and 0 otherwise.

GET PROPERTY RequiresEncryptionKey of database;

Read-only system property. Return 1 if object is a structure-encrypted and 0 otherwise.

GET PROPERTY StructureEncrypted of database;

For vServer only. Read-write system property. Operates with access-control-list (ACL) database setting.

GET PROPERTY ACL of database;
-- to allow only 192.168/16 subnet to connect:
SET PROPERTY ACL of database TO "-0.0.0.0/0,+192.168.0.0/16";

Read-write system property. Operates with CenturyBound database setting. Default value is 20.

GET PROPERTY CenturyBound of database;
SET PROPERTY CenturyBound of database TO 20;

Read-write system property. Operates with Century1 database setting. Default value is 1900.

GET PROPERTY Century1 of database;
SET PROPERTY Century1 of database TO 1900;

Read-write system property. Operates with Century2 database setting. Default value is 2000.

GET PROPERTY Century2 of database;
SET PROPERTY Century2 of database TO 2000;

Read-write system property. Operates with DateTimeFormat database setting.

GET PROPERTY DateTimeFormat of database;
SET PROPERTY DateTimeFormat of database TO 'kDMY';

Read-write system property. Operates with DateSeparator database setting.

GET PROPERTY DateSeparator of database;
SET PROPERTY DateSeparator of database TO '.';

Read-only system property. Operates with IndexCount database value.

GET PROPERTY IndexCount of database;

[NEW in v5.0]

Read-write system property. Operates with database journal mode setting. Returns TRUE if this database is Journaled. On default, starting from v5.0, journaling is ON.

You can assign this property to FALSE at runtime for an opened database. You may set it to FALSE (to get better speed (+20%)), but it is not recommended.

GET PROPERTY Journaled of database;
SET PROPERTY Journaled of database TO False;

[NEW in v7.3.3]

Read-write system property. Returns TRUE if this database is monitored. The default value is false.

After turn “IsMonitoring” property on you will see a new system table

__QueryStatistic__

Now, you can get data from there as using API so via SQL. Turning that property OFF leads to drop that table.

You can assign this property to TRUE or FALSE at any moment for an opened database. Usually, you should set it to TRUE only for profiling purposes (to find some “bottleneck” queries). It is not recommended to keep it on in production because it could affect query performance.

GET PROPERTY IsMonitored of database;
SET PROPERTY IsMonitored of database TO False;

Read-only system property. Operates with LinkCount database value.

GET PROPERTY LinkCount of database;

Read-write system property. Operates with database mode setting. Can not be changed if database already exists. Modification is allowed in CREATE DATABASE statement only.

GET PROPERTY Mode of database;
SET PROPERTY Mode of database TO 'kDscDatBlbInd';

Read-only system property. Operates with ProcedureCount database value.

GET PROPERTY ProcedureCount of database;

Read-only system property. Operates with PropertyCount database value.

GET PROPERTY PropertyCount of database;

Read-only system property. Return the path to database.

GET PROPERTY Path of database;

Read-write system property. Operates with segment size of database volume setting. Can not be changed if database already exists. Modification is allowed in CREATE DATABASE statement only.

GET PROPERTY SegmentSize of database;
SET PROPERTY SegmentSize of database TO 32768;

Read-write system property. Operates with database SchemaVersion value. Initial value is 1.

GET PROPERTY SchemaVersion of database;
SET PROPERTY SchemaVersion of database TO 2;

[NEW in v6.1]

Read-only system property. Operates with database SchemaChangesCounter value. This value is incremented internally in case of any db schema changes.

GET PROPERTY SchemaChangesCounter of database;

Read-only system property. Return the size of database in bytes.

GET PROPERTY Size of database;

Read-only system property. Return the StorageType of database.

GET PROPERTY StorageType of database;

Read-write system property. Operates with TimeSeparator database setting.

GET PROPERTY TimeSeparator of database;
SET PROPERTY TimeSeparator of database TO ':';

Read-only system property. Return the count of triggers value.

GET PROPERTY TriggerCount of database;

Read-only system property. Return the count of views value.

GET PROPERTY ViewCount of database;