TSqlTable

Abstract base class for tables that can be queried using SQL statements.

Inheritance

Level	Ancestor	Description
1	TObject	Ultimate ancestor in a class hierarchy
2	TBaseObject	A base class for objects that can be used instead of `TObject`.
3	TSqlTable

Source

Sql.Table.pas (49)

Description

Models the structure of a specific SQL table, including its columns, primary key, unique keys and foreign keys. Instances of TSQLTable descendants, together with their declared columns, can be used in SQL statements and prevent the need to use literal text identifiers in SQL statements.

Fields

Scope	Visibility	Type	Name
Instance	private	TSqlScope	FScope
Instance	private	TDocumentNode	FCaption
Instance	private	TText	FAliasName
Instance	private	TSqlObjectFactory	FObjectFactory
Instance	protected	TList<TSqlTableColumn>	FColumns
Instance	protected	TSet<TSqlTableColumn>	FDefaultHiddenColumns
Instance	protected	TSqlPrimaryKey	FPrimaryKey
Instance	protected	TList<TSqlUniqueKey>	FUniqueKeys
Instance	protected	TList<TSqlForeignKey>	FForeignKeys
Instance	protected	TList<TSqlIndex>	FIndexes
Instance	protected	TSqlTableColumnOrder	FOrder
Instance	protected	TSqlScope	TableScope
Instance	public	TText	TableIdentifier
Instance	public	TSqlLifetimeInterface	Lifetime
Instance	public	TSqlBranchSetInterface	BranchSet
Instance	public	TSqlTable	UnversionedTable
Instance	public	TBoolean	SupportsTransactions
Instance	public	TBoolean	IsTemporary
Instance	public	TBoolean	IsRecord
Type	public	TBoolean	GloballySuppressPrimaryKeyException

Methods

Scope	Visibility	Result	Name
Instance	private		SetAliasName(Value: TText)
Instance	private		SetObjectFactory(Value: TSqlObjectFactory)
Instance	protected	TText	GetIdentifier()
Instance	protected		SetCaption(Value: TDocumentNode)
Instance	protected		SetScope(Value: TSqlScope)
Instance	protected	TBoolean	SuppressPrimaryKeyException()
Instance	protected	TBoolean	ShouldCheckPrimaryKey()
Instance	protected		CheckPrimaryKey()
Instance	public		Create(Identifier: TText)
Instance	public		Destroy()
Instance	public		AfterConstruction()
Instance	public	TText	ToText()
Instance	public	TType	GetType()
Instance	public	TRecordType	CreateKeyType()
Instance	public	TSqlTableExpression	ToExpression()
Instance	public	TBoolean	ShouldAutoRefresh()
Instance	public	TSqlTableExpression	Current()
Instance	public	TSqlTableExpression	At(RevisionId: TInteger)
Instance	public	TSqlTableExpression	History()
Instance	public	TSqlTableExpression	ForMethod(Method: TDataMethod)
Instance	public	TSqlTableColumn	CreateColumn(Identifier: TText; Type_: TType)
Instance	public	TSqlTableColumn	CreateColumn(Identifier: TText; Caption: TDocumentNode; Type_: TType)
Instance	public	TSqlTableColumn	CreateColumn(SourceColumn: TSqlTableColumn)
Instance	public	TSqlTableColumn	CreateColumn(SourceColumn: TSqlResultSetColumn)
Instance	public	TSqlExpression	IsMethodAllowedExpression(Method: TDataMethod)
Instance	public		Insert(Database: TSqlDatabase; Columns: TList<TSqlTableColumn>; Rows: TList<TSqlRow>)
Instance	public		Update(Database: TSqlDatabase; Assignments: TList<TSqlAssign>; Restrictions: TList<TSqlExpression>)
Instance	public		Delete(Database: TSqlDatabase; Restrictions: TList<TSqlExpression>)
Instance	public	TSqlPrimaryKey	SetPrimaryKey(Columns: array of TSqlTableIndexColumn)
Instance	public	TSqlUniqueKey	AddUniqueKey(Name: TText; Columns: array of TSqlTableIndexColumn)
Instance	public	TSqlNonUniqueIndex	AddNonUniqueIndex(Name: TText; Columns: array of TSqlTableIndexColumn)
Instance	public	TSqlSpatialIndex	AddSpatialIndex(Name: TText; Columns: array of TSqlTableIndexColumn)
Instance	public	TSqlForeignKey	AddForeignKey(Name: TText; Columns: array of TSqlTableIndexColumn; ReferenceTable: TSqlTable; ReferenceColumns: array of TSqlTableColumn; Type_: TSqlForeignKeyType)
Instance	public	TList<TSqlTableColumn>	GetNonBranchingColumns()
Instance	public		AddVersioning(Log: TSqlTransactionLog)
Instance	public		AddBranching(Handler: TBranchSetHandler)
Instance	public	TBoolean	IsBranching()
Instance	public		AddAggregate(Function_: TAggregateFunction; Columns: array of TSqlTableColumn)