Valentina Table Properties

On this page you can see list of system Valentina Table 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 Table t1;
SET PROPERTY AlternateHandling of Table t1 to 'kDefault';

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

GET PROPERTY CaseFirst of Table t1;
SET PROPERTY CaseFirst of Table t1 to 'kDefault';

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

GET PROPERTY CaseLevel of Table t1;
SET PROPERTY CaseLevel of Table t1 to 'kDefault';

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

GET PROPERTY FrenchCollation of Table t1;
SET PROPERTY FrenchCollation of Table t1 to 'kDefault';

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

GET PROPERTY HiraganaQuaternaryMode of Table t1;
SET PROPERTY HiraganaQuaternaryMode of Table t1 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 Table t1;
SET PROPERTY IOEncoding of Table t1 to 'UTF-16';

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

GET PROPERTY LocaleName of Table t1;
SET PROPERTY LocaleName of Table t1 to 'en_US';

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

GET PROPERTY NormalizationMode of Table t1;
SET PROPERTY NormalizationMode of Table t1 to 'kDefault';

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

GET PROPERTY NumericCollation of Table t1;
SET PROPERTY NumericCollation of Table t1 to 'kDefault';

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

GET PROPERTY Strength of Table t1;
SET PROPERTY Strength of Table t1 to 'kDefault';

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

GET PROPERTY Encrypted of of Table t1;

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

GET PROPERTY RequiresEncryptionKey of Table t1;

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

GET PROPERTY StructureEncrypted of Table t1;

Read-only system property. Return fields count of the table.

GET PROPERTY FieldCount of Table t1;

Read-only system property. Return ID of the table.

GET PROPERTY ID of Table t1;

Read-only system property. Return indexes count of the table.

GET PROPERTY IndexCount of Table t1;

Read-only system property. Return links count of the table.

GET PROPERTY LinkCount of Table t1;

Read-only system property. Return methods count of the table.

GET PROPERTY MethodCount of Table t1;

Read-only system property. Return properties count of the table.

GET PROPERTY PropertyCount of Table t1;

Read-only system property. Return physical records count of the table.

GET PROPERTY PhysicalRecordCount of Table t1;

Read-only system property. Return list of field names which are participated in primary key of the table.

GET PROPERTY PrimaryKey of Table t1;

Read-only system property. Return the name of primary key constraint of the table.

GET PROPERTY PrimaryKeyConstraint of Table t1;

Read-only system property. Return records count of the table.

GET PROPERTY RecordCount of Table t1;

Read-only system property. Return storage type of the table (kStorage_Disk, kStorage_RAM).

GET PROPERTY StorageType of Table t1;

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

GET PROPERTY Size of Table t1;

Read-only system property. Return storage kind of the table (kTblPermanent, kTblSystem, kTblTemporary, kTblResultTable).

GET PROPERTY TableKind of Table t1;

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

GET PROPERTY TriggerCount of Table t1;