Deveel.Data.Sql.Tables Namespace Reference

Classes
class	BaseDataTable
class	ColumnInfo
	Defines the metadata properties of a column within a table of a database. More...
class	CompositeTable
class	ConstraintDeferrabilityExtensions
class	ConstraintInfo
class	ConstraintViolationException
	A database exception that represents a constraint violation. More...
class	FilterTable
class	FunctionTable
class	GeneratedTable
interface	IMutableTable
	An interface that defines contracts to alter the contents of a table. More...
interface	IQueryTable
interface	IRootTable
	Interface that is implemented by all root tables. More...
interface	ITable
	Defines the contract to access the data contained into a table of a database. More...
interface	ITableContainer
	A container for any system tables that are generated from information inside the database engine. More...
interface	ITableSource
interface	ITableSourceComposite
class	JoinedTable
class	LimitedTable
class	MutableTableExtensions
class	NaturallyJoinedTable
class	OuterTable
class	QueryContextExtensions
class	QueryExtensions
class	RawTableInfo
class	ReferenceTable
class	RootTable
class	Row
	A single row in a table of a database. More...
struct	RowId
	Defines the value of a ROWID object, that is a unique reference within a database system to a single row. More...
class	SimpleRowEnumerator
class	SubsetColumnTable
class	Table
class	TableInfo
	Defines the metadata properties of a table existing within a database. More...
class	TableInternalExtensions
class	TableManager
class	TableQueryExtensions
	Provides a set of extension methods to ITable and IMutableTable objects. More...
class	TableSource
class	TableSourceGC
class	TemporaryTable
class	UserContextTable
	A wrapper around a table that fires triggers on table events. More...
class	VersionedTableIndexList
class	VirtualTable

Enumerations
enum	ConstraintDeferrability : short { ConstraintDeferrability.InitiallyDeferred = 4, ConstraintDeferrability.InitiallyImmediate = 5, ConstraintDeferrability.NotDeferrable = 6 }
	The type of deferrance of a constraint. More...
enum	ConstraintType { ConstraintType.PrimaryKey = 1, ConstraintType.Unique = 2, ConstraintType.ForeignKey = 3, ConstraintType.Check = 4 }
	An enumeration of all the supported kinds of constraints within a table or a schema. More...
enum	ForeignKeyAction { ForeignKeyAction.NoAction = 0, ForeignKeyAction.Cascade = 1, ForeignKeyAction.SetNull = 2, ForeignKeyAction.SetDefault = 3 }
	Enumerates the foreign key referential trigger actions. More...

Enumeration Type Documentation

enum Deveel.Data.Sql.Tables.ConstraintDeferrability : short

strong

The type of deferrance of a constraint.

Enumerator
InitiallyDeferred	The constraint is checked at the COMMIT of each transaction.
InitiallyImmediate	The constraint is checked immediately after each single statement.
NotDeferrable	A constraint whose check cannot be deferred to the COMMIT of a trasnaction.

Definition at line 23 of file ConstraintDeferrability.cs.

                                        : short {
        InitiallyDeferred = 4,
        
        InitiallyImmediate = 5,
        
        NotDeferrable = 6,
    }

enum Deveel.Data.Sql.Tables.ConstraintType

strong

An enumeration of all the supported kinds of constraints within a table or a schema.

Enumerator
PrimaryKey	summary> A PRIMARY KEY constraint. /summary> With this constraint, the 'column_list' list contains the names of the columns in this table that are defined as the primary key. There may only be one primary key constraint per table. summary> A UNIQUE constraint. /summary> With this constraint, the 'column_list' list contains the names of the columns in this table that must be unique.
Unique	summary> A FOREIGN_KEY constraint. /summary> With this constraint, the 'table_name' string contains the name of the table that this is a foreign key for, the 'column_list' list contains the list of foreign key columns, and 'column_list2' optionally contains the referenced columns.
ForeignKey	summary> A CHECK constraint. /summary> With this constraint, the 'expression' object contains the expression that must evaluate to true when adding a column to the table.
Check

Definition at line 24 of file ConstraintType.cs.

                               {
        PrimaryKey = 1,

        Unique = 2,

        ForeignKey = 3,

        Check = 4
    }

enum Deveel.Data.Sql.Tables.ForeignKeyAction

strong

Enumerates the foreign key referential trigger actions.

Enumerator
NoAction	No actions to be done on the foreign key trigger.
Cascade
SetNull	Sets the value of the reference column to null.
SetDefault	Sets the default value of the referenced column, if any was set.

Definition at line 23 of file ForeignKeyAction.cs.

                                 {
        NoAction = 0,

        Cascade = 1,

        SetNull = 2,

        SetDefault = 3
    }