Switch to: V11V10V9V8V7V6V5

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.

Localizable properties

AlternateHandling

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';

CaseFirst

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';

CaseLevel

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';

FrenchCollation

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';

HiraganaQuaternaryMode

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';

IOEncoding

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';

LocaleName

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

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

NormalizationMode

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';

NumericCollation

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';

Strength

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

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

Encryptable properties

Encrypted

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

GET PROPERTY Encrypted of of Table t1;

RequiresEncryptionKey

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

GET PROPERTY RequiresEncryptionKey of Table t1;

StructureEncrypted

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

GET PROPERTY StructureEncrypted of Table t1;

Table properties

FieldCount

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

GET PROPERTY FieldCount of Table t1;

ID

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

GET PROPERTY ID of Table t1;

IndexCount

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

GET PROPERTY IndexCount of Table t1;

LinkCount

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

GET PROPERTY LinkCount of Table t1;

MethodCount

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

GET PROPERTY MethodCount of Table t1;

PropertyCount

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

GET PROPERTY PropertyCount of Table t1;

PhysicalRecordCount

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

GET PROPERTY PhysicalRecordCount of Table t1;

PrimaryKey

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

GET PROPERTY PrimaryKey of Table t1;

PrimaryKeyConstraint

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

GET PROPERTY PrimaryKeyConstraint of Table t1;

RecordCount

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

GET PROPERTY RecordCount of Table t1;

StorageType

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

GET PROPERTY StorageType of Table t1;

Size

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

GET PROPERTY Size of Table t1;

TableKind

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

GET PROPERTY TableKind of Table t1;

TriggerCount

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

GET PROPERTY TriggerCount of Table t1;