Database Manipulation Language

Article
06/18/2008

The following table lists commands and functions that make it possible to manipulate databases.

Use	To
ADATABASES( ) Function	Place the names and paths of all open databases into an array.
ADD TABLE Command	Add a free table to the current database.
APPEND PROCEDURES Command	Append stored procedures in a text file to the stored procedures in the current database.
AUSED( ) Function	Place table aliases and work areas for a data session into a variable array.
CLOSE Commands	Close various file types.
COMPILE Command	Compile the specified source files and create an object file for each one.
COPY PROCEDURES Command	Copy stored procedures in the current database to a text file.
CREATE CONNECTION Command	Create a named connection and stores it in the current database.
CREATE DATABASE Command	Create a database and open it.
CREATE SQL VIEW Command	Display the View Designer, where you can create a SQL view.
CREATE TRIGGER Command	Create a Delete, Insert, or Update trigger for a table.
CREATEOFFLINE( ) Function	Take an existing view offline.
DROPOFFLINE( ) Function	Discard all changes made to an offline view and take the offline view back online.
CURSORGETPROP( ) Function	Retrieve the current property settings for a Visual FoxPro table or a cursor.
CURSORSETPROP( ) Function	Specify property settings for a Visual FoxPro table or a cursor.
CURVAL( ) Function	Return field values directly from disk for a table or a remote data source.
DATETIME( ) Function	Return the current date and time as a DateTime value, or create a year 2000-compliant DateTime value.
DBC( ) Function	Return the name and path of the current database.
DBGETPROP( ) Function	Retrieve the value of a property for the current database or for fields, named connections, tables, or views in the current database.
DBSETPROP( ) Function	Set a property for the current database or for fields, named connections, tables, or views in the current database.
DBUSED( ) Function	Return true (.T.) if the specified database is open.
DELETE - SQL Command	Mark records for deletion.
DELETE CONNECTION Command	Delete a named connection from the current database.
DELETE DATABASE Command	Delete a database from disk.
DELETE TRIGGER Command	Remove a trigger for a table from the current database.
DELETE VIEW Command	Delete a SQL view from the current database.
DISPLAY CONNECTIONS Command	Display information about the named connections in the current database.
DISPLAY DATABASE Command	Display information about the current database or fields, named connections, tables, or views in the current database.
DISPLAY PROCEDURES Command	Display the names of procedures stored in the current database.
DISPLAY TABLES Command	Display names and information about all the tables contained in the current database.
DISPLAY VIEWS Command	Display information about SQL views in the current database.
FREE TABLE Command	Remove a database reference from a table.
GETFLDSTATE( ) Function	Return a numeric value indicating the status of a field in a table or cursor.
GETNEXTMODIFIED( ) Function	Return the record number for the next modified record in a buffered table or cursor.
INDBC( ) Function	Return whether a specified database object is in the current database.
ISEXCLUSIVE( ) Function	Return whether a specified database is opened exclusively.
LIST CONNECTIONS Command	Display information about the named connections in the current database.
LIST DATABASE Command	Display information about the current database.
LIST PROCEDURES Command	Display the names of stored procedures in the current database.
LIST TABLES Command	Display the table information contained in the current database.
LIST VIEWS Command	Display the information about SQL views in the current database.
MODIFY CONNECTION Command	Display the Connection Designer.
MODIFY DATABASE Command	Display the Database Designer.
MODIFY PROCEDURE Command	Open the Visual FoxPro text editor.
MODIFY VIEW Command	Display the View Designer.
OLDVAL( ) Function	Return original field values for fields that have been modified but not updated.
OPEN DATABASE Command	Open a database.
PACK DATABASE Command	Remove records marked for deletion from the current database.
REFRESH( ) Function	Refresh data in an updatable SQL remote or local view or CursorAdapter cursor.
REMOVE TABLE Command	Remove a table from the current database.
RENAME CONNECTION Command	Rename a named connection in the current database.
RENAME TABLE Command	Rename a table in the current database.
RENAME VIEW Command	Rename a SQL view in the current database.
REQUERY( ) Function	Retrieve data again for a SQL view.
SET DATABASE Command	Specify the current database.
SET DATASESSION Command	Activate the specified form's data session.
SETFLDSTATE( ) Function	Assign a field modification or deletion state value to a field or record in a table or cursor.
SQLCANCEL( ) Function	Request cancellation of an executing SQL statement.
SQLCOLUMNS( ) Function	Store column information for a specified data source table in a cursor.
SQLCOMMIT( ) Function	Commit a transaction.
SQLCONNECT( ) Function	Establish a connection to a data source.
SQLDISCONNECT( ) Function	Terminate a connection to a data source.
SQLEXEC( ) Function	Send a SQL statement to the data source, where the statement is processed.
SQLGETPROP( ) Function	Retrieve the current settings for an active connection.
SQLMORERESULTS( ) Function	Copy another result set to a Visual FoxPro cursor if more result sets are available.
SQLROLLBACK( ) Function	Cancel any changes made during the current transaction.
SQLSETPROP( ) Function	Specify settings for an active connection.
SQLSTRINGCONNECT( ) Function	Establish a connection to a data source using a connection string.
SQLTABLES( ) Function	Store the names of tables in a data source to a Visual FoxPro cursor.
TABLEREVERT( ) Function	Discard changes made to a buffered row, buffered table, or cursor.
TABLEUPDATE( ) Function	Commit changes made to a buffered row, a buffered table, cursor, or cursor adapter.
_TRIGGERLEVEL System Variable	Contains a read-only numeric value indicating the current trigger procedure nesting level.
VALIDATE DATABASE Command	Ensure that the locations of tables and indexes in the current database are correct.

Share via

Database Manipulation Language

See Also

Other Resources

Additional resources