Lianja/SQL Commands and Functions

A

• ADATABASES()
• ADD TABLE
• SQL Aggregate Functions
• ALTER DATABASE
• ALTER INDEX
• ALTER TABLE
• ALTER VIRTUALTABLE
• AUTO INCREMENT Column Constraint
• AUTOINC Column Constraint
• AUTOSUGGESTIONHEADERS Column Constraint
• AUTOSUGGESTIONS Column Constraint
• AVG()

B

• BACKUP DATABASE
• SQL BEGIN TRANSACTION
• BETWEEN Predicate

C

• CALCULATED Column Constraint
• CAST()
• CHARINDEX()
• CHECK Column Constraint
• CHECK DATABASE
• CHECK TABLE
• CHECK Table Constraint
• CHECKUNIQUE Column Constraint
• CHOICES Column Constraint
• CHOOSE()
• CLEAR SMARTQUERY
• CLEARRESULTSET()
• CLOSE
• SQL CLOSE
• CLOSE DATABASE
• CLOSE DATABASES
• CLOSE TABLES
• COMMIT
• COMPARE DATABASE
• COMPARE TABLE
• COMPILE DATABASE
• SQL Constraints
• COPY DATABASE
• COUNT()
• CREATE CURSOR
• CREATE DATABASE
• CREATE INDEX
• CREATE PROCEDURE
• CREATE TABLE
• CREATE TRIGGER
• CREATE VIEW
• SQL CREATE VIEW
• CREATE VIRTUALTABLE
• CURRVAL
• CURSYNCNUM()

D

• Data Types
• SQL Data Types
• Database Events
• DATABASE()
• DBC AFTERDELETE
• DBC AFTERINSERT
• DBC AFTEROPENDATA
• DBC AFTEROPENTABLE
• DBC AFTERUPDATE
• DBC BEFOREDELETE
• DBC BEFOREINSERT
• DBC BEFOREOPENTABLE
• DBC BEFOREUPDATE
• DBC CLOSEDATA
• DBC OPENDATA
• DBC()
• DBUSED()

D cont.

• DECLARE CURSOR
• DEFAULT Column Constraint
• SQL DELETE
• DELETE TRIGGER
• DESCRIPTION Column Constraint
• DISPLAY TABLES
• DROP CURSOR
• DROP DATABASE
• DROP INDEX
• DROP PROCEDURE
• DROP TABLE
• DROP VIEW

E

• SQL END TRANSACTION
• ERROR Column Constraint
• Error Messages: SQL
• ERROR Table Constraint
• EXECJAVASCRIPT()
• EXECPHP()
• EXECPYTHON()
• EXECSCRIPT()
• EXECUTE
• EXECUTE IMMEDIATE
• EXPLAIN

F

• FETCH
• FOREIGN KEY Column Constraint
• FOREIGN KEY Table Constraint

G

• GETDATAMAPPING Column Constraint
• GETRESULTSET()
• GRANT
• GUID()

H

• HELP Column Constraint

I

• IN Predicate
• INDEX Table Constraint
• INSERT
• SQL INSERT

K

• KEY Table Constraint

L

• LIKE Predicate
• LIST DATABASE
• LIST TABLES
• LOCK TABLE

M

• SQL MAX()
• SQL MIN()

N

• NEXTVAL
• NOCPTRANS Column Constraint
• NOT NULL Column Constraint
• NULL Column Constraint
• NULL Predicate

O

• ONAFTERDELETE Table Constraint
• ONAFTERINSERT Table Constraint
• ONAFTERUPDATE Table Constraint
• ONBEFOREDELETE Table Constraint
• ONBEFOREINSERT Table Constraint
• ONBEFOREUPDATE Table Constraint
• ONCLOSE Table Constraint
• ONDELETE Table Constraint
• ONINSERT Table Constraint
• ONOPEN Table Constraint
• ONUPDATE Table Constraint
• OPEN
• OPEN DATABASE
• SQL Operators
• SQL Date operators
• SQL Logical operators
• SQL Numeric operators
• SQL Relational operators
• SQL String operators

P

• PACK DATABASE

P cont.

• PICTURE Column Constraint
• PREDICATES
• SQL Predicates
• PREPARE
• PRIMARY KEY Column Constraint
• PRIMARY KEY Table Constraint
• PSEUDO COLUMNS

R

• RANGE Column Constraint
• RDO AFFECTED ROWS()
• RDO CLOSE()
• RDO CONNECT()
• RDO DATA SEEK()
• RDO ERRNO()
• RDO ERROR()
• RDO EXEC()
• RDO FETCH ARRAY()
• RDO FETCH ASSOC()
• RDO FETCH FIELD()
• RDO FETCH LENGTHS()
• RDO FETCH OBJECT()
• RDO FETCH ROW()
• RDO FIELD FLAGS()
• RDO FIELD LEN()
• RDO FIELD NAME()
• RDO FIELD SEEK()
• RDO FIELD TABLE()
• RDO FIELD TYPE()
• RDO FREE OBJECT()
• RDO FREE RESULT()
• RDO GET CLIENT INFO()
• RDO GET HOST INFO()
• RDO INFO()
• RDO LIST DBS()
• RDO NUM FIELDS()
• RDO NUM ROWS()
• RDO PING()
• RDO QUERY()
• RDO REAL ESCAPE STRING()
• RDO RESULT()
• RDO SELECT DB()
• RDO STAT()
• RDO THREAD ID()
• RDO UNBUFFERED QUERY()
• REBUILD DATABASE
• RECALCULATE Column Constraint
• REFERENCES Column Constraint
• REINDEX DATABASE
• SQL Remote Data Connectivity Functions
• REMOVE TABLE
• RESTORE DATABASE
• REVOKE
• SQL ROLLBACK
• ROWID
• ROWNUM()

S

• SAVE TRANSACTION
• SAVEPOINT
• SQL SELECT
• SET CHECK Column Constraint
• SET EXPLAIN
• SET NULL
• SET NULLDISPLAY
• SET SMARTQUERY
• SET SQL
• SET SQLDIALECT
• SET SQLROWID
• SET TRANSACTION