2.1 is no longer sold or supported - these pages are for reference purposes only. VistaDB 3.x should be used for all new development.
VistaDB 2.1 SQL-92 Support
VistaDB 2.1 features a robust SQL query processor that supports
SQL-92 syntax. Click here to see our new
VistaDB 3.0 SQL support
SQL Commands
| SQL
Command |
Extra Commands
and Clauses |
| SELECT |
Extracts data
from one or more fields from one or more tables
Aliases (AS and
IN)
CASE
DISTINCT
FROM
GROUP BY [HAVING]
IS [NOT] NULL
JOIN
(INNER, LEFT, LEFT OUTER)
LASTIDENTITY
LIKE
ORDER
BY
WHERE
RIGHT [OUTER] JOIN and FULL [OUTER] JOIN are supported in
3.0 |
| INSERT |
The INSERT
statement is used to add or append records to tables. |
| UPDATE |
The UPDATE
statement is used to update, modify or change data in tables. |
| DELETE |
The DELETE
statement is used to remove rows in tables. |
| CREATE
DATABASE |
This command is
used to create new VistaDB database.
COLLATE |
| CREATE
TABLE |
This command is
used to create new table inside a VistaDB database.
NULL [NOT
NULL]
IDENTITY
DEFAULT
CAPTION
HIDDEN
COMPRESSED
ENCRYPTED
READONLY
Constraints:
CHECK
PRIMARY
KEY
FOREIGN KEY
REFERENCES
ON UPDATE [CASCADE]
ON DELETE
[CASCADE] |
| ALTER TABLE |
The ALTER TABLE
command is used to change data tables
DROP COLUMN
ADD COLUMN |
| DROP TABLE |
The DROP TABLE
statement is used to delete the specified table from the database. |
| CREATE
INDEX |
The CREATE INDEX
statement is used to create a new index for a given table.
UNIQUE
ASC |
DESC
CASE SENSITIVE |
| DROP INDEX |
The DROP INDEX
statement is used to delete the specified index from the database. |
| CREATE
TRIGGER |
This command is
used to create a new Trigger. |
| DROP
TRIGGER |
The DROP TRIGGER
statement is used to delete the specified trigger from the database. |
| ALTER
TRIGGER |
This command is
used to change an existing Trigger. |
| START
TRANSACTION |
Starts a
transaction |
| COMMIT
TRANSACTION |
Commits a
transaction |
| ROLLBACK
TRANSACTION |
Rollback a
transaction |
Aggregate Functions
| SQL
Clauses |
Notes |
| AVG |
Returns the
average of the values in a specified column or an expression. |
| COUNT |
Counts the
number of rows retrieved by a SELECT statement. |
| MAX |
Calculates the
largest value for a numeric column. |
| MIN |
Calculate the
smallest value for a numeric column. |
| STDEV |
Computes the
standard deviation. |
| SUM |
Returns the sum
of all values in a column. |
Arithmetic Functions
| SQL
Clauses |
Notes |
| ABS |
Returns the
absolute value of the argument. |
| ACRTAN |
Calculates the
arctangent of the given number. |
| COS |
Returns the
cosine of the angle X, in radians. |
| EXP |
Returns the
value of e raised to the power of X, where e is the base of the natural
logarithms. |
| FRAC |
Returns the
fractional part of the argument X. |
| INT |
Returns the
Integer position of a Float value. |
| LN |
Returns the
natural logarithm (Ln(e) = 1) of the float-type expression X. |
| MINOF |
Returns the
lowest value of the n figures. |
| MAXOF |
Returns the
highest value of the n figures. |
| PI |
Pi, approximated
as 3.1415926535897932385. |
| POWER |
Raises Base to
any power. |
| ROUND |
Rounds a
float-type value to an integer-type value. |
| ROUNDDEC |
Rounds a
float-type value to a given precision (decimals). |
| SIN |
Returns the sine
of the argument. |
| SQR |
Returns the sine
of the argument. |
| SQRT |
Returns the
square root of the argument. |
| TRUNC |
Truncates a
float-type value to an integer-type value. |
| TRUNCDEC |
Truncates a
float-type value to a given precision (decimals). |
Conditional Functions
| SQL
Clauses |
Notes |
| IF |
Evaluates a
Boolean statement, returning one value for True and another for False. |
Date and Time Functions
| SQL
Clauses |
Notes |
| NOW |
Returns the
current system date in floating point format. |
| DAY |
Return the day
for the given date |
| EXTRACT |
Used to get Day,
Month and Year values |
| MONTH |
Return the month
for the given date |
| YEAR |
Return the year
for the given date |
| HOUR |
Return the hour
for the given time |
| MIN |
Return the
minutes for the given time |
| MSEC |
Return the
milliseconds for the given time |
| SEC |
Return the
seconds for the given time |
String Functions
| SQL
Clauses |
Notes |
| COPY |
Returns a
substring of a string. |
| EXTRACT |
Formats the
series of arguments in the list of arguments |
| FORMAT |
Formats the
series of arguments in the list of arguments |
| FORMATDATETIME |
Formats the
date-and-time value given by DateTime using a specified format |
| FORMATFLOAT |
Formats the
floating-point value given by Value using a specified format |
| LEFT |
Returns the
leftmost Count characters contained in a string. |
| LENGTH |
Returns the
number of characters actually used in a string. |
| LOWER |
Returns a string
converted to lowercase. |
| POS |
Searches for a
substring within a string. |
| RIGHT |
Returns the
rightmost Count characters contained in a string. |
| SUBSTRING |
Extracts a
substring from a table column or character literal |
| TRIM |
Deletes the
leading or trailing character, or both, from a table column. |
| UPPER |
Returns a string
converted to uppercase. |
|
Purchase |
Products |
Downloads |
Forums |
Blog |
Free Trial
