Class bpxForeignKey
- Namespace
- PolarDataInterop.Catalog
- Assembly
- PolarDataInterop.dll
This class contains the details of a relationship (foreign key).
public class bpxForeignKey
- Inheritance
-
bpxForeignKey
- Inherited Members
- Extension Methods
Properties
DeleteRule
Returns the DeleteRule. One of: 'CASCADE', 'SET_NULL', 'RESTRICTED'
public string DeleteRule { get; }
Property Value
ForeignKeyRelationships
Returns all detail relationships (the fields).
public Collection<bpxForeignKeyRelationship> ForeignKeyRelationships { get; }
Property Value
HasIndex
Returns a boolean indicating an index was found that matches the fields in this relationship.
public bool HasIndex { get; }
Property Value
Name
Returns the name
public string Name { get; }
Property Value
PKtableName
Returns the name of the table containing the primary key (that is referred to).
public string PKtableName { get; }
Property Value
UpdateRule
Returns the UpdateRule
public string UpdateRule { get; }
Property Value
Methods
CreateForeignKeyConstraintSQL(string)
Creates the SQL expression to create a foreign key constraint for this relationship.
public string CreateForeignKeyConstraintSQL(string pTableName)
Parameters
pTableName
stringThe name of the table to use.
Returns
- string
The ALTER TABLE statement to create this foreign key constraint.
ToString(clsString)
public void ToString(clsString pResult)
Parameters
pResult
clsString