SQL 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.
As of right now the following DDL statements are supported:
CREATE INDEX IX_IndexName ON TableName (ColumnName)
DROP INDEX IX_IndexName ON TableName
CREATE TABLE TableName
(
BooleanColumn boolean,
DecimalColumn decimal,
DoubleColumn double,
FloatColumn, float,
IntColumn int,
UIntColumn uint,
TextColumn text
)
DROP TABLE TableName
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 |
ALTER TABLE TableName
DROP COLUMN ColumnName
ALTER TABLE TableName
ADD ColumnName (TextColumn text)
Last modified 3yr ago