Difference between revisions of "Category:SQL"

A

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

B

• BACKUP DATABASE
• SQL BEGIN TRANSACTION
• BETWEEN Predicate

C

• CALCULATED Column Constraint
• CAST()
• CHECK Column Constraint
• CHECK Table Constraint
• CLEAR SMARTQUERY
• CLEARRESULTSET()
• SQL CLOSE
• CLOSE DATABASE
• CLOSE TABLES
• COMMIT
• COMPILE DATABASE
• SQL Constraints
• COPY DATABASE
• COUNT()
• SQL CREATE BRIDGE
• CREATE CONNECTION
• CREATE CURSOR
• CREATE DATABASE
• CREATE INDEX
• CREATE PROCEDURE
• CREATE TABLE
• CREATE TRIGGER
• SQL CREATE VIEW
• CURRVAL
• CURSORNAME()
• CURSYNCNUM()

D

• SQL Data Types
• SQL Database Events
• DATABASE()
• DBC CLOSEDATA
• DBC OPENDATA
• DBUSED()
• DECLARE CURSOR
• DEFAULT Column Constraint
• SQL DELETE
• DELETE TRIGGER
• DESCRIPTION Column Constraint
• DISPLAY TABLES
• DROP BRIDGE
• DROP CONNECTION
• 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
• EXEC SQL
• EXECSCRIPT()
• EXECUTE
• EXECUTE IMMEDIATE
• EXPLAIN

F

• FETCH

F cont.

• FINDCURSOR()
• FOREIGN KEY Column Constraint
• FOREIGN KEY Table Constraint

G

• GETRESULTSET()
• GRANT

I

• IN Predicate
• INDEX Table Constraint
• 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

• ODBC: Function Summary
• ODBC: Supported SQL Grammar
• ONCLOSE Table Constraint
• ONDELETE Table Constraint
• ONINSERT Table Constraint
• ONOPEN Table Constraint
• ONROLLBACK 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
• SQL Overview

P

• PACK DATABASE
• SQL Predicates
• PREPARE
• PRIMARY KEY Column Constraint
• PRIMARY KEY Table Constraint
• SQL 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()

R cont.

• 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
• SET CHECK Column Constraint
• SET GATEWAY
• SET NULL
• SET NULLDISPLAY
• SET PAUSE
• SET SMARTQUERY
• SET SQL
• SET SQLDIALECT
• SET SQLPROMPT
• SET SQLROWID
• SET TCACHE
• SET TRANSACTION
• SET XMLFORMAT
• SETRESULTSET()
• SQLCANCEL()
• SQLCNT
• SQLCODE
• SQLCOLUMNS()
• SQLCOMMIT()
• SQLCONNECT()
• SQLDISCONNECT()
• SQLERROR()
• SQLEXEC()
• SQLGETPROP()
• SQLMORERESULTS()
• SQLPREPARE()
• SQLROLLBACK()
• SQLSETPROP()
• SQLSTRINGCONNECT()
• SQLTABLES()
• SQLVALUES()
• SUM()
• SYNCNUM()
• SYSACTIVEUSERS
• SYSALERTS
• SYSBESTROWIDENTIFIER
• SYSCATALOGS
• SYSCOLUMNCONSTRAINTS
• SYSCOLUMNPRIVILEGES