Table

Database table

BrowseName
Table
SuperType
Object(BaseObjectType)

Properties

Name BrowseName DataType Description
Record limit RecordLimit UInt32 Maximum limit of records (rows) in the table. When the limit is reached, the new data replace the old data in rotation
Columns Columns Store column Table columns. Collection of StoreColumns. For ODBC database: Microsoft SQL Server maximum columns limit = 1000, maximum limit of characters in the column = 128; MySQL Server maximum columns limit = 1024, maximum limit of characters in the column = 64. For embedded database: maximum columns limit = 2000, maximum limit of characters in the column = 1024

Methods

Add column

BrowseName
AddColumn

Add a new column to the store

Table 1. InputArguments
Name DataType Description
Name String Column name
DataType NodeId Column DataType

Remove column

BrowseName
RemoveColumn

Remove this column from the store

Table 2. InputArguments
Name DataType Description
Name String Name of the column to be removed

Rename column

BrowseName
RenameColumn

Name of the column to be renamed

Table 3. InputArguments
Name DataType Description
OldName String Name of column to be renamed
NewName String The new column name

Insert

BrowseName
Insert

Isert data to the store

Table 4. InputArguments
Name DataType Description
ColumnNames String Column names for insert
Values BaseDataType List of records to be inserted