Store¶

BrowseName: Store
SuperType: Object (BaseObjectType)

Properties¶

Name	BrowseName	DataType	Description
Max column name length	MaxColumnNameLength	UInt32	Maximum length of column names
Max columns count	MaxColumnCount	UInt32	Max columns count
Data type compatibility map	DataTypeCompatibilityMap	NodeId	Map of the compatibility for the column data type
Status	Status	StoreStatus	Database connectivity status
Tables	Tables	Collection of Table	Database tables

Methods¶

Add Table¶

BrowseName: AddTable

InputArguments

Name	DataType	Description
Name	String	Name of the new table

Remove table¶

BrowseName: RemoveTable

InputArguments

Name	DataType	Description
Name	String	Name of table to be removed

Rename Table¶

BrowseName: RenameTable

InputArguments

Name	DataType	Description
OldName	String	Name of table to be renamed
NewName	String	New name for the table

Query¶

BrowseName: Query

ANSI SQL query

InputArguments

Name	DataType	Description
Query	String	ANSI SQL query

OutputArguments

Name	DataType	Description
Header	String	Query column header
ResultSet	BaseDataType	Query result set

Open query¶

BrowseName: QueryOpen

InputArguments

Name	DataType	Description
Query	String	ANSI SQL query

OutputArguments

Name	DataType	Description
QueryHandle	Guid	Handle that represents the open query
Header	String	Query column header
Count	UInt64	Count of the elements resulting from the query

Query page¶

BrowseName: QueryPage

InputArguments

Name	DataType	Description
QueryHandle	Guid	Handle that represents the open query
Offset	UInt32	Paged query offset
Size	UInt32

OutputArguments

Name	DataType	Description
ResultSet	BaseDataType	Query result set

Close query¶

BrowseName: QueryClose

InputArguments

Name	DataType	Description
QueryHandle	Guid	Handle that represents the open query

Add column¶

BrowseName: AddColumn

InputArguments

Name	DataType	Description
TableName	String	Table name
Name	String	Column name
DataType	NodeId	Column DataType

Remove column¶

BrowseName: RemoveColumn

InputArguments

Name	DataType	Description
TableName	String	Table name
Name	String

Rename column¶

BrowseName: RenameColumn

InputArguments

Name	DataType	Description
TableName	String	Table name
OldName	String	Name of column to be renamed
NewName	String	The new column name

Insert¶

BrowseName: Insert

InputArguments

Name	DataType	Description
TableName	String	Table name
ColumnNames	String	Column names for insert
Values	BaseDataType	List of records to be inserted