# StatementType

enum StatementType : Enum<StatementType>

Possible SQL statement types, most often represented by the leading word in the command syntax.

## Entries

SELECT
Link copied to clipboard
SELECT

A SELECT statement to query data.

INSERT
Link copied to clipboard
INSERT

An INSERT statement to insert new records.

UPDATE
Link copied to clipboard
UPDATE

An UPDATE statement to modify existing records.

DELETE
Link copied to clipboard
DELETE

A DELETE statement to delete existing records.

GRANT
Link copied to clipboard
GRANT

A GRANT statement to provide privileges on database objects.

CREATE
Link copied to clipboard
CREATE

A CREATE statement to create database objects.

ALTER
Link copied to clipboard
ALTER

An ALTER statement to modify database objects.

TRUNCATE
Link copied to clipboard
TRUNCATE

A TRUNCATE statement to delete data in a database object.

DROP
Link copied to clipboard
DROP

A DROP statement to delete database objects.

EXEC
Link copied to clipboard
EXEC

An EXEC statement to execute a stored procedure or command.

PRAGMA
Link copied to clipboard
PRAGMA

A PRAGMA statement to configure or query the internal database state.

SHOW
Link copied to clipboard
SHOW

A SHOW statement to provide information about database objects.

MULTI
Link copied to clipboard
MULTI

Represents multiple statements of mixed types concatenated in a single string.

OTHER
Link copied to clipboard
OTHER

Represents statements not covered by existing constants.

MERGE
Link copied to clipboard
MERGE

A MERGE statement to insert, update, or delete values by comparing data between source and destination tables.

## Properties

entries
Link copied to clipboard
val entries: EnumEntries<StatementType>

Returns a representation of an immutable list of all enum entries, in the order they're declared.

group
Link copied to clipboard
val group: StatementGroup

The StatementGroup associated with the SQL statement.

name
Link copied to clipboard
val name: String
ordinal
Link copied to clipboard
val ordinal: Int

## Functions

valueOf
Link copied to clipboard
fun valueOf(value: String): StatementType

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

values
Link copied to clipboard
fun values(): Array<StatementType>

Returns an array containing the constants of this enum type, in the order they're declared.