Six new properties have been added to both the Table and Column objects.

Column object:

  • IsPrimaryOnlyKey: Returns True if the column is a primary key and not also a foreign key
  • IsForeignOnlyKey: Returns True if the column is a foreign key and not also a primary key

Table object:

  • HasPrimaryOnlyKey: Returns True if the table has at least one primary key that is not also a foreign key
  • PrimaryOnlyKeys: Returns the primary keys collection that are not also foreign keys of the current table
  • HasForeignOnlyKey: Returns True if the table has at least one foreign key that is not also a primary key
  • ForeignOnlyKeys: Returns the foreign keys collection that are not also primary keys of the current table

The product documentation has been updated.