banDropColumn

Diagnostic Category: lint/safety/banDropColumn

Since: vnext

Note

This rule is recommended. A diagnostic error will appear when linting your code.

Sources: - Inspired from: squawk/ban-drop-column

Description

Dropping a column may break existing clients.

Update your application code to no longer read or write the column.

You can leave the column as nullable or delete the column once queries no longer select or modify the column.

Examples

Invalid

alter table test drop column id;

code-block.sql lint/safety/banDropColumn ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

  × Dropping a column may break existing clients.

  i You can leave the column as nullable or delete the column once queries no longer select or modify the column.

How to configure


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