TableDifference

Index

Properties

• addedChecks
• addedColumns
• addedForeignKeys
• addedIndexes
• addedPolicies
• addedTriggers
• changedChecks
• changedColumns
• changedComment
• changedForeignKeys
• changedIndexes
• changedPartitioning
• changedRlsEnabled
• changedRlsForced
• changedTriggers
• fromTable
• name
• removedChecks
• removedColumns
• removedForeignKeys
• removedIndexes
• removedPolicies
• removedTriggers
• renamedColumns
• renamedIndexes
• toTable

Properties

addedChecks

addedChecks: Dictionary<CheckDef<unknown>>

addedColumns

addedColumns: Dictionary<Column>

addedForeignKeys

addedForeignKeys: Dictionary<ForeignKey>

addedIndexes

addedIndexes: Dictionary<IndexDef>

addedPolicies

addedPolicies: Dictionary<SqlPolicyDef>

addedTriggers

addedTriggers: Dictionary<SqlTriggerDef>

changedChecks

changedChecks: Dictionary<CheckDef<unknown>>

changedColumns

changedColumns: Dictionary<ColumnDifference>

optionalchangedComment

changedComment?: string

changedForeignKeys

changedForeignKeys: Dictionary<ForeignKey>

changedIndexes

changedIndexes: Dictionary<IndexDef>

optionalchangedPartitioning

changedPartitioning?: { from?: TablePartitioning; to?: TablePartitioning }

Type declaration

• optionalfrom?: TablePartitioning

• optionalto?: TablePartitioning

optionalchangedRlsEnabled

changedRlsEnabled?: boolean

New RLS enable state, present only when it changed.

optionalchangedRlsForced

changedRlsForced?: boolean

New RLS force state, present only when it changed.

changedTriggers

changedTriggers: Dictionary<SqlTriggerDef>

fromTable

fromTable: DatabaseTable

name

name: string

removedChecks

removedChecks: Dictionary<CheckDef<unknown>>

removedColumns

removedColumns: Dictionary<Column>

removedForeignKeys

removedForeignKeys: Dictionary<ForeignKey>

removedIndexes

removedIndexes: Dictionary<IndexDef>

removedPolicies

removedPolicies: Dictionary<SqlPolicyDef>

Changed policies surface as removedPolicies + addedPolicies pairs (drop + recreate).

removedTriggers

removedTriggers: Dictionary<SqlTriggerDef>

renamedColumns

renamedColumns: Dictionary<Column>

renamedIndexes

renamedIndexes: Dictionary<IndexDef>

toTable

toTable: DatabaseTable