SQL Queries

Data Manipulation Language (DML) Queries

Starcounter 3.0 has the same SQL Query Processor as Starcounter 2.3.2. Please refer to the original documentation for the full specification.

Data Definition Language (DDL) Queries

As of right now the following DDL statements are supported:

Create / drop database index

CREATE INDEX IX_IndexName ON TableName (ColumnName)
DROP INDEX IX_IndexName ON TableName

Create / drop database table

CREATE TABLE TableName
(
BooleanColumn boolean,
DecimalColumn decimal,
DoubleColumn double,
FloatColumn, float,
IntColumn int,
UIntColumn uint,
TextColumn text
)
DROP TABLE TableName

Starcounter database vs .NET CLR data types

There is no one to one match between Starcounter database data types and .NET CLR data types.

Use the following table to translate .NET CLR data type names into Starcounter database SQL data type names.

.NET CLR Data Type

Starcounter database data type

Boolean

boolean

Byte

int

Byte[]

binary

DateTime

uint

Decimal

decimal

Double

double

Float

float

Int16

int

Int32

int

Int64

int

SByte

int

String

text

UInt16

uint

UInt32

uint

UInt64

uint

Create / drop database table column

ALTER TABLE TableName
DROP COLUMN ColumnName
ALTER TABLE TableName
ADD ColumnName (TextColumn text)