SQL Guide : solidDB® SQL statements
  
solidDB® SQL statements
This section provides descriptions of 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.
See
ADMIN COMMAND
ADMIN EVENT
ALTER SEQUENCE
ALTER TABLE
ALTER TRIGGER
ALTER USER
CALL
COMMIT WORK
CREATE CACHE SEGMENT
CREATE CATALOG
CREATE EVENT
CREATE FUNCTION
CREATE FUNCTION (external)
CREATE INDEX
CREATE PROCEDURE
CREATE PROCEDURE (external)
CREATE [OR REPLACE] PUBLICATION
CREATE ROLE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SYNC BOOKMARK
CREATE TABLE
CREATE TRIGGER
CREATE USER
CREATE VIEW
DELETE
DESCRIBE
DROP CACHE SEGMENT
DROP CATALOG
DROP EVENT
DROP FUNCTION
DROP INDEX
DROP MASTER
DROP PROCEDURE
DROP PUBLICATION
DROP PUBLICATION REGISTRATION
DROP REPLICA
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
HINT
IMPORT
INSERT
LIST
LOCK TABLE
MESSAGE
POST EVENT
REFRESH
REGISTER EVENT
REVOKE
REVOKE REFRESH
ROLLBACK WORK
SAVE
SAVE PROPERTY
SELECT
SET
SET TRANSACTION
START AFTER COMMIT
TRUNCATE TABLE
UNLOCK TABLE
UNREGISTER EVENT
UPDATE
WAIT EVENT
Common clauses