Specifying RESTRICT Mode

The RESTRICT keyword can control the drop operation for supertables, for tables that have referential constraints and views defined on them, or for tables that have violations and diagnostics tables associated them. Using the RESTRICT option causes the drop operation to fail and an error message to be returned if any of the following conditions are true:
  • Existing referential constraints reference table.
  • Existing views are defined on table.
  • Any violations tables or diagnostics tables are associated with table.
  • The table is the supertable in an inheritance hierarchy.