Usually, the command type is determined automatically from the text of the SQL statement. The following values are available for the property TFDCommand.CommandKind to cater for cases where the internal parser might be unable to make correct, unambiguous assumptions based on the statement text alone:

skUnknown

unknown. Tells the internal parser to determine the command type automatically from its analysis of the text of the command

skStartTransaction

a command for starting a transaction

a command for ending and committing a transaction

skRollback

a command for ending and rolling back a transaction

a CREATE …​ command for creating a new metadata object

skAlter

an ALTER …​ command for altering a metadata object

skDrop

a DROP …​ command for deleting a metadata object

skSelect

a SELECT command for retrieving data

skSelectForLock

a SELECT …​ WITH LOCK command for locking the selected rows

an INSERT …​ command for inserting a new record

an UPDATE …​ command for modifying records

skDelete

a DELETE …​ command for deleting records

skMerge

a MERGE INTO …​ command

skExecute

an EXECUTE PROCEDURE or EXECUTE BLOCK command

skStoredProc

a stored procedure call

skStoredProcNoCrs

a call to a stored procedure that does not return a cursor

a call to a stored procedure that returns a cursor