dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteAuthorizerActionCode Enumeration

On this page
    SQLiteAuthorizerActionCode Enumeration
    On this page
    Specifies an action of a SQL statement. The action is passed to the SQLiteAuthorizerHandler authorizer.
    Syntax
    'Declaration
     
    Public Enum SQLiteAuthorizerActionCode 
       Inherits System.Enum
       Implements System.IComparable, System.IConvertible, System.IFormattable 
    public enum SQLiteAuthorizerActionCode : System.Enum, System.IComparable, System.IConvertible, System.IFormattable  
    Members
    MemberDescription
    AlterTableSpecifies an ALTER TABLE statement.
    The value is 26.
    The arg1 parameter is a database name, and the arg2 parameter is a table name.
    AnalyzeSpecifies an ANALYZE statement.
    The value is 28.
    The arg1 parameter is a table name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    AttachSpecifies an ATTACH DATABASE statement.
    The value is 24.
    The arg1 parameter is a file name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    CopyNot used by modern versions of SQLite.
    The value is 0.
    CreateIndexCreates an index.
    The value is 1.
    The arg1 parameter is an index name, and the arg2 parameter is a table name.
    CreateTableCreates a table.
    The value is 2.
    The arg1 parameter is a table name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    CreateTempIndexCreates a temporary index.
    The value is 3.
    The arg1 parameter is an index name, and the arg2 parameter is a table name.
    CreateTempTableCreates a temporary table.
    The value is 4.
    The arg1 parameter is a table name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    CreateTempTriggerCreates a temporary trigger.
    The value is 5.
    The arg1 parameter is a trigger name, and the arg2 parameter is a table name.
    CreateTempViewCreates a temporary view.
    The value is 6.
    The arg1 parameter is a view name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    CreateTriggerCreates a trigger.
    The value is 7.
    The arg1 parameter is a trigger name, and the arg2 parameter is a table name.
    CreateViewCreates a view.
    The value is 8.
    The arg1 parameter is a view name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    CreateVTableCreates a virtual table.
    The value is 29.
    The arg1 parameter is a table name, and the arg2 parameter is a module name.
    DeleteDeletes rows from a table.
    The value is 9.
    The arg1 parameter is a table name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    DetachSpecifies a DETACH DATABASE statement.
    The value is 25.
    The arg1 parameter is a database name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    DropIndexDrops an index.
    The value is 10.
    The arg1 parameter is an index name, and the arg2 parameter is a table name.
    DropTableDrops a table.
    The value is 11.
    The arg1 parameter is a table name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    DropTempIndexDrops a temporary index.
    The value is 12.
    The arg1 parameter is an index name, and the arg2 parameter is a table name.
    DropTempTableDrops a temporary table.
    The value is 13.
    The arg1 parameter is a table name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    DropTempTriggerDrops a temporary trigger.
    The value is 14.
    The arg1 parameter is a trigger name, and the arg2 parameter is a table name.
    DropTempViewDrops a temporary view.
    The value is 15.
    The arg1 parameter is a view name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    DropTriggerDrops a trigger.
    The value is 16.
    The arg1 parameter is a trigger name, and the arg2 parameter is a table name.
    DropViewDrops a view.
    The value is 17.
    The arg1 parameter is a view name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    DropVTableDrops a virtual table.
    The value is 30.
    The arg1 parameter is a table name, and the arg2 parameter is a module name.
    FunctionCalls a function.
    The value is 31.
    The arg1 parameter is a null reference (Nothing in Visual Basic), and the arg2 parameter is a function name.
    InsertInserts rows into a table.
    The value is 18.
    The arg1 parameter is a table name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    PragmaSpecifies a PRAGMA statement.
    The value is 19.
    The arg1 parameter is a PRAGMA name, and the arg2 parameter is the first argument of the PRAGMA or a null reference (Nothing in Visual Basic).
    ReadReads a column of a table.
    The value is 20.
    The arg1 parameter is a table name, and the arg2 parameter is a column name or an empty string when no column of the table is read, for example, in SELECT count(*).
    RecursiveSpecifies a recursive common table expression.
    The value is 33.
    The arg1 parameter is a null reference (Nothing in Visual Basic), and the arg2 parameter is a null reference (Nothing in Visual Basic).
    ReindexSpecifies a REINDEX statement.
    The value is 27.
    The arg1 parameter is an index name, and the arg2 parameter is a null reference (Nothing in Visual Basic).
    SavepointSpecifies a SAVEPOINT, RELEASE, or ROLLBACK TO statement.
    The value is 32.
    The arg1 parameter is an operation (BEGIN, RELEASE, or ROLLBACK), and the arg2 parameter is a savepoint name.
    SelectSpecifies a SELECT statement.
    The value is 21.
    The arg1 parameter is a null reference (Nothing in Visual Basic), and the arg2 parameter is a null reference (Nothing in Visual Basic).
    TransactionSpecifies a BEGIN, COMMIT, or ROLLBACK statement.
    The value is 22.
    The arg1 parameter is an operation (BEGIN, COMMIT, or ROLLBACK), and the arg2 parameter is a null reference (Nothing in Visual Basic).
    UpdateUpdates a column of a table.
    The value is 23.
    The arg1 parameter is a table name, and the arg2 parameter is a column name.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             Devart.Data.SQLite.SQLiteAuthorizerActionCode

    See Also