banTruncateCascade

Diagnostic Category: lint/safety/banTruncateCascade

Since: vnext

Sources:

• Inspired from: <a href="https://squawkhq.com/docs/ban-truncate-cascade" target="_blank"><code>squawk/ban-truncate-cascade</code></a>

Description

Using TRUNCATE's CASCADE option will truncate any tables that are also foreign-keyed to the specified tables.

So if you had tables with foreign-keys like:

a <- b <- c

and ran:

truncate a cascade;

You'd end up with a, b, & c all being truncated!

Instead, you can manually specify the tables you want.

truncate a, b;

How to configure

{
  "linter": {
    "rules": {
      "safety": {
        "banTruncateCascade": "error"
      }
    }
  }
}