CEDE 2024 (12.0) Database Reference
tCascadeDeleteOption Table
AIRReference Database : tCascadeDeleteOption Table
Description

Stores codes that represent the type of data to delete during a delete operation.

Properties
Creation Date12/17/2015 3:43 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows15
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CascadeDeleteOptionCode

Code that represents the type of data being deleted.

  • 1 = Cascade delete associated exposure view
  • 2 = Cascade delete associated exposure set
  • 3 = Cascade delete associated exposure view and exposure set
  • 4 = Cascade delete associated analysis results
  • 5 = Cascade delete associated exposure view and analysis results
  • 6 = Cascade delete associated exposure set and analysis results
  • 7 = Cascade delete associated exposure view, exposure set and analysis results
  • 8 = Cascade delete associated reinsurance program
  • 9 =  Cascade delete associated exposure view and reinsurance program
  • 10 = Cascade delete associated exposure set and reinsurance program
  • 11 = Cascade delete associated exposure view, exposure set and reinsurance program
  • 12 = Cascade delete associated analysis results and reinsurance program
  • 13 = Cascade delete associated exposure view, analysis results and reinsurance program
  • 14 = Cascade delete associated exposure set, analysis results and reinsurance program
  • 15 = Cascade delete associated exposure view, exposure set, analysis results and reinsurance program
int4   
 Description

Description of the code. 

Corresponds to the code in CascadeDeleteOptionCode.

varchar1024  
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2024. Extreme Event Solutions.

Please send your feedback or questions to SoftwareDocumentationFeedback@verisk.com.