solidDB Help : solidDB reference : SQL: Statements
  
SQL: Statements
The following topics describe the solidDB SQL statements, including examples.
solidDB uses SQL syntax based on the ANSI X3H2 and IEC/ISO 9075 SQL standards. The SQL‑89 Level 2 and SQL‑92 Entry level standards are fully supported, including important ANSI X3H2‑1992 (SQL‑92) extensions. Many features of full SQL‑92, SQL‑99, and SQL‑2003 standards are also supported.
The following syntax notation conventions are used:
 
Syntax
Description
SELECT
( ) , . ' "
Keywords are capitalized and bold. Required punctuation is also in bold.
tablename
Variable names are in italics.
[ ]
Square brackets indicate optional items.
|
A vertical bar separates two mutually exclusive choices in a syntax line.
{ }
Curly brackets delimit a set of mutually exclusive choices in a syntax line.
An ellipsis indicates that arguments can be repeated several times.
See
ADMIN COMMAND
ADMIN EVENT
ALTER GRID
ALTER REPLICATION CONNECTION
ALTER REPLICATION PARTITION
ALTER REPLICATION SUBSCRIPTION
ALTER SEQUENCE
ALTER TABLE
ALTER TRIGGER
ALTER USER
CALL
COMMIT
CREATE CACHE SEGMENT
CREATE CATALOG
CREATE EVENT
CREATE FUNCTION
CREATE GRID
CREATE INDEX
CREATE PROCEDURE
CREATE [OR REPLACE] PUBLICATION
CREATE REPLICATION CONNECTION
CREATE REPLICATION PARTITION
CREATE REPLICATION SUBSCRIPTION
CREATE ROLE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SYNC BOOKMARK
CREATE TABLE
CREATE TRIGGER
CREATE USER
CREATE VIEW
DELETE FROM
DESCRIBE
DESCRIBE REPLICATION
DROP CACHE SEGMENT
DROP CATALOG
DROP EVENT
DROP FUNCTION
DROP INDEX
DROP MASTER
DROP PROCEDURE
DROP PUBLICATION
DROP PUBLICATION REGISTRATION
DROP REPLICA
DROP REPLICATION CONNECTION
DROP REPLICATION PARTITION
DROP REPLICATION SUBSCRIPTION
DROP ROLE
DROP SCHEMA
DROP SEQUENCE
DROP SUBSCRIPTION
DROP SYNC BOOKMARK
DROP TABLE
DROP TRIGGER
DROP USER
DROP VIEW
EXPLAIN PLAN FOR
EXPORT SUBSCRIPTION
EXPORT SUBSCRIPTION TO REPLICA
GRANT
GRANT REFRESH
Hints
IMPORT
INSERT INTO
LIST
LOCK TABLE
MESSAGE
POST EVENT
REFRESH
REGISTER EVENT
REVOKE
REVOKE REFRESH
ROLLBACK
SAVE
SAVE PROPERTY
SELECT
SET
SET TRANSACTION
START AFTER COMMIT
START REPLICATION
STOP REPLICATION
TRUNCATE TABLE
UNLOCK TABLE
UNREGISTER EVENT
UPDATE
WAIT EVENT
Common clauses
Pseudo columns in SELECT statement
Date and time literals
Wildcard characters