Share via

Database Manipulation

  • Article

These commands and functions manipulate databases.

ADATABASES( ) Function

ADD TABLE Command

APPEND PROCEDURES Command

AUSED( ) Function

CLOSE Commands

COMPILE DATABASE Command

COPY PROCEDURES Command

CREATE CONNECTION Command

CREATE DATABASE Command

CREATE SQL VIEW Command

CREATE TRIGGER Command

CREATEOFFLINE( ) Function

DROPOFFLINE( ) Function

CURSORGETPROP( ) Function

CURSORSETPROP( ) Function

CURVAL( ) Function

DATETIME( ) Function

DBC( ) Function

DBGETPROP( ) Function

DBSETPROP( ) Function

DBUSED( ) Function

DELETE - SQL Command

DELETE CONNECTION Command

DELETE DATABASE Command

DELETE TRIGGER Command

DELETE VIEW Command

DISPLAY CONNECTIONS Command

DISPLAY DATABASE Command

DISPLAY PROCEDURES Command

DISPLAY TABLES Command

DISPLAY VIEWS Command

FREE TABLE Command

GETFLDSTATE( ) Function

GETNEXTMODIFIED( ) Function

INDBC( ) Function

ISEXCLUSIVE( ) Function

LIST CONNECTIONS Command

LIST DATABASE Command

LIST PROCEDURES Command

LIST TABLES Command

LIST VIEWS Command

MODIFY CONNECTION Command

MODIFY DATABASE Command

MODIFY PROCEDURE Command

MODIFY VIEW Command

OLDVAL( ) Function

OPEN DATABASE Command

PACK DATABASE Command

REFRESH( ) Function

REMOVE TABLE Command

RENAME CONNECTION Command

RENAME TABLE Command

RENAME VIEW Command

REQUERY( ) Function

SET DATABASE Command

SET DATASESSION Command

SETFLDSTATE( ) Function

SQLCANCEL( ) Function

SQLCOLUMNS( ) Function

SQLCOMMIT( ) Function

SQLCONNECT( ) Function

SQLDISCONNECT( ) Function

SQLEXEC( ) Function

SQLGETPROP( ) Function

SQLMORERESULTS( ) Function

SQLROLLBACK( ) Function

SQLSETPROP( ) Function

SQLSTRINGCONNECT( ) Function

SQLTABLES( ) Function

TABLEREVERT( ) Function

TABLEUPDATE( ) Function

_TRIGGERLEVEL System Variable

VALIDATE DATABASE Command