Class DbMetaTable

Namespace

Tripous.Data

Assembly

Tripous.Data.dll

Represents metadata for a database table, including its structural components and schema relationships.

public class DbMetaTable : DbMetaObject

Inheritance

object

DbMetaObject

DbMetaTable

Inherited Members

DbMetaObject.Name

DbMetaObject.SchemaName

DbMetaObject.SourceCode

DbMetaObject.DisplayText

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

TypeExtensions.InheritsFrom(object, Type)

Properties

Columns

Gets the collection of schema column metadata objects defined for the table.

public List<DbMetaColumn> Columns { get; }

Property Value

List<DbMetaColumn>

Constraints

Gets the collection of general schema constraint metadata objects defined for the table.

public List<DbMetaConstraint> Constraints { get; }

Property Value

List<DbMetaConstraint>

ForeignKeys

Gets the collection of foreign key constraint metadata objects defined for the table.

public List<DbMetaForeignKey> ForeignKeys { get; }

Property Value

List<DbMetaForeignKey>

Indexes

Gets the collection of index metadata objects defined for the table optimization.

public List<DbMetaIndex> Indexes { get; }

Property Value

List<DbMetaIndex>

Triggers

Gets the collection of schema trigger metadata objects associated with the table events.

public List<DbMetaTrigger> Triggers { get; }

Property Value

List<DbMetaTrigger>

Methods

GetCreateTable()

Generates a basic SQL DDL script statement for creating the table schema.

public string GetCreateTable()

Returns

string

GetFieldNameList()

Generates a comma-separated string list of all column names in the table, separated by newlines.

public string GetFieldNameList()

Returns

string