DeveelDB  20151217
complete SQL database system, primarly developed for .NET/Mono frameworks
Classes | Enumerations
Deveel.Data.Sql.Statements Namespace Reference

Classes

class  AddColumnAction
 
class  AddConstraintAction
 
class  AlterTableStatement
 
class  AlterTableStatementTests
 
class  AlterUserStatement
 
class  CloseStatement
 
class  ColumnChecker
 
class  CreateSchemaStatement
 
class  CreateSequenceStatement
 
class  CreateTableStatement
 The statement object used to create a table in a database. More...
 
class  CreateTableStatementTests
 
class  CreateUserStatement
 
class  CreateUserStatementTests
 
class  CreateViewStatement
 
class  CreateViewStatementTests
 
class  DeclareCursorStatement
 
class  DeclareCursorStatementTests
 
class  DeclareVariableStatement
 
class  DropColumnAction
 
class  DropConstraintAction
 
class  DropDefaultAction
 
class  DropPrimaryKeyAction
 
class  DropSchemaStatement
 
class  DropTableStatement
 
class  DropTableStatementTests
 
class  DropViewStatement
 
class  FetchStatement
 
class  GrantPrivilegesStatement
 
class  GrantRoleStatement
 
class  GrantTests
 
interface  IAlterTableAction
 
interface  IAlterUserAction
 
class  InsertIntoStatementTests
 
class  InsertSelectStatement
 
class  InsertStatement
 
interface  IParentExecutable
 
interface  IPreparableStatement
 
interface  IStatement
 
class  LoopControlStatement
 
class  OpenStatement
 
class  OpenStatementTests
 
class  PlSqlBlock
 
class  PreparationRequiredException
 
class  QueryExtensions
 
class  RaiseStatement
 
class  SelectIntoStatement
 
class  SelectStatement
 
class  SelectStatementTests
 
class  SetAccountStatusAction
 
class  SetDefaultAction
 
class  SetPasswordAction
 
class  SetUserGroupsAction
 
class  SetUserStatusStatement
 
class  SqlColumnAssignment
 
class  SqlStatement
 Represents the foundation class of SQL statements to be executed. More...
 
class  SqlTableColumn
 
class  SqlTableConstraint
 
class  StatementCache
 A wrapper around a specialized ICache used to store and retrieve parsed SqlStatement objects. More...
 
class  StatementException
 
class  StatementExecutor
 This class is used to transform an input query to a set of statements and execute them within a given query. More...
 
class  StatementExtensions
 
class  StatementPrepareException
 An exception that happens during the SqlStatement.Prepare(IExpressionPreparer, IQueryContext). More...
 
class  UpdateFromCursorStatement
 
class  UpdateQueryStatement
 
class  UpdateStatement
 
class  UpdateStatementTests
 

Enumerations

enum  AlterTableActionType {
  AlterTableActionType.AddColumn = 1, AlterTableActionType.DropColumn = 2, AlterTableActionType.AddConstraint = 3, AlterTableActionType.DropConstraint = 4,
  AlterTableActionType.DropPrimaryKey = 5, AlterTableActionType.SetDefault = 6, AlterTableActionType.DropDefault = 7
}
 The possible types of actions in a AlterTableAction expression. More...
 
enum  AlterUserActionType { AlterUserActionType.SetPassword =1, AlterUserActionType.SetAccountStatus = 2, AlterUserActionType.SetGroups = 3 }
 
enum  LoopControlType { LoopControlType.Break = 1, LoopControlType.Continue = 2, LoopControlType.Exit = 3 }
 

Enumeration Type Documentation

The possible types of actions in a AlterTableAction expression.

Enumerator
AddColumn 

Adds a defined column to a table.

DropColumn 

Modifies a table by removing a given column.

AddConstraint 

Adds a new constraint to the table.

DropConstraint 

Drops a named constraint from a table.

DropPrimaryKey 

Drops a PRIMARY KEY constraint from a table.

SetDefault 

Alters a table column setting the DEFAULT expression.

DropDefault 

Drops the DEFAULT expression from a given column.

Definition at line 24 of file AlterTableActionType.cs.

24  {
28  AddColumn = 1,
29 
33  DropColumn = 2,
34 
38  AddConstraint = 3,
39 
43  DropConstraint = 4,
44 
48  DropPrimaryKey = 5,
49 
53  SetDefault = 6,
54 
58  DropDefault = 7,
59  }
Drops the DEFAULT expression from a given column.
Modifies a table by removing a given column.
Drops a PRIMARY KEY constraint from a table.
Alters a table column setting the DEFAULT expression.