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)

star tool

Last modified 3yr ago

.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`