Table Class

Get data table information for data processing

Inheritance Hierarchy

SystemObject
GSF.DataTable

Namespace: GSF.Data
Assembly: GSF.Core (in GSF.Core.dll) Version: 2.4.230-beta+03417d7b5cff037b24e882d7adef82d359b34964

Syntax

[SerializableAttribute]
public class Table : IComparable, IComparable<Table>

<SerializableAttribute>
Public Class Table
	Implements IComparable, IComparable(Of Table)

[SerializableAttribute]
public ref class Table : IComparable, IComparable<Table^>

[<SerializableAttribute>]
type Table = 
    class
        interface IComparable
        interface IComparable<Table>
    end

GSF.Data.Table = function();

Type.createClass(
	'GSF.Data.Table',
	null,
	IComparable,
	IComparable`1);

The Table type exposes the following members.

Constructors

	Name	Description
	Table	Creates a new Table.
	Table(String)	Creates a new Table.
	Table(String, String, String, String, String, Int32)	Creates a new Table.

Properties

	Name	Description
	AutoIncField	Gets auto-increment field for the Table, if any.
	Catalog	Get or set catalog information for Table
	Connection	Get IDbConnection of object
	Description	Get or set description
	Fields	Get or set list of Fields for Table
	FullName	Get or set full name of Table
	HasAutoIncField	Gets flag that determines if the Table has an auto-increment field.
	IdentitySQL	Get or set identity SQL for Table
	IsForeignKeyTable	Get flag of any foreign key Field
	IsLinked	Get flag for TableType alias or link
	IsSystem	Check for system tables and system views
	IsTemporary	Get flag for TableType for temp
	IsView	Check for object is view
	MapName	Get or set name of Table
	Name	Get name of Table
	Parent	Get parent Table information
	PrimaryKeyFieldCount	Get count for primary key Field
	Priority	Get or set priority
	Process	Get or set process flag
	ReferencedByForeignKeys	Get flag that determines if the table has any foreign keys.
	RowCount	Get row count in Table
	Schema	Get or set schema name
	SQLEscapedName	Get SQL escaped name of Table
	Type	Get TableType

Methods

	Name	Description
	CalculateRowCount	Calculates row count.
	CompareTo(Object)	Compare Object type of obj with Table object Priority
	CompareTo(Table)	Compare Table with other Table object Priority
	DefineForeignKey	Check for ForeignKeyField
	DefinePrimaryKey	check for primary key field in Table
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object)
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object)
	GetHashCode	Serves as the default hash function. (Inherited from Object)
	GetType	Gets the Type of the current instance. (Inherited from Object)
	IsReferencedBy	Check for direct table reference by otherTable.
	IsReferencedVia	Checks for indirect table reference through otherTable.
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object)
	ReevalulateIdentitySQL	Re-evaluates identity SQL for database type.
	ToString	Gets display name for table. (Overrides ObjectToString)
	UsesDefaultSchema	Get schema information flag based on DatabaseType

Extension Methods

	Name	Description
	GetEnumValueOrDefault	Gets the enumeration constant for value, if defined in the enumeration, or a default value. (Defined by EnumExtensions)
	GetEnumValueOrDefaultT	Gets the enumeration constant for this value, if defined in the enumeration, or a default value. (Defined by EnumExtensions)