Click or drag to resize

Table Class

Represents a server Table or View.
Inheritance Hierarchy

Namespace:  MySqlX.XDevAPI.Relational
Assembly:  MySql.Data (in MySql.Data.dll) Version: 8.0.22
Syntax
public class Table : DatabaseObject

The Table type exposes the following members.

Properties
  NameDescription
Public propertyIsView
Gets a value indicating whether the object is a View (True) or a Table (False).
Public propertyName
Gets the database object name.
(Inherited from DatabaseObject.)
Public propertySchema
Gets the schema that owns the database object.
(Inherited from DatabaseObject.)
Public propertySession
Gets the session that owns the database object.
(Inherited from DatabaseObject.)
Top
Methods
  NameDescription
Public methodCount
Returns the number of rows in the table on the server.
Public methodDelete
Creates a TableDeleteStatement. This method is intended to delete rows from a table.
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodExistsInDatabase
Verifies if the table exists in the database.
(Overrides DatabaseObjectExistsInDatabase.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodInsert
Creates a TableInsertStatement set with the fileds to insert to. The table insert statement can be further modified before exeuction. This method is intended to insert one or multiple rows into a table.
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodSelect
Creates a TableSelectStatement set with the columns to select. The table select statement can be further modified before execution. This method is intended to select a set of table rows.
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Public methodUpdate
Creates a TableUpdateStatement. This method is intended to update table rows values.
Protected methodValidateOpenSession (Inherited from DatabaseObject.)
Top
See Also